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/
