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?
-alex
