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! :)