On Fri, 22 Jun 2001, Alex Pilosov wrote: > On Fri, 22 Jun 2001, Thomas T. Thai wrote: > > > > Huh? That *is* the generic, fully-SQL-standard way. > > > > the project i'm doing this for is opensource and i need it to work in both > > postgresql and mysql. the above statement wouldn't work in mysql. > MySQL is not a standards conforming database. You must not ask on > postgresql list for a workaround against mysql brain-damage. > > Alternatively, the answer to your question (assuming you must get it to > work on mysql and assuming that mysql does not understand the 'union'), is > to do two separate queries on these tables and join them together in your > perl code. But you knew that, right? yes, but i was looking at the one query thing. i'm cheap! :) ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
