[cfaussie] Re: MySQL Views

[Shane Farmer]

Sorry, meant

select
    t1.value as firstname,
    t2.value as lastname,
    t3.value as email
from
    table t1,
    table t2,
    table t3
where
    t1.fieldid = 1 and
    t2.fieldid  = 2 and
    t3.fieldid = 3 --- You are currently subscribed to cfaussie as: archive@mail-archive.com To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/