Do you know where your variables are? | |
PerlMonks |
Re: (OT) MySQL select Questionby dws (Chancellor) |
on Jul 27, 2003 at 00:13 UTC ( [id://278165]=note: print w/replies, xml ) | Need Help?? |
Can anyone suggest a way to make this work?
MySQL 4.0 adds support for UNION. With that (and assuming table1 and table2 have the same columns), you could do something like: If you're stuck with an older version of MySQL, you're probably faced with running the two queries separately, then merging the results.
In Section
Seekers of Perl Wisdom
|
|