Thats the reason why the aliases 't1' 't2' and 't3' are being used...
Should work. I'm doing something very similar (mySQL, but only two fields) and it works a treat...
B)
Ricardo Russon wrote:
The only problem is that t1 t2 and t3 are all the same table.
:(
Shane Farmer wrote:
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: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
-- Brett Payne-Rhodes Eaglehawk Computing t: +61 (0)8 9371-0471 f: +61 (0)8 9371-0470 m: +61 (0)414 371 047 e: [EMAIL PROTECTED] w: www.ehc.net.au
--- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
