On 1/7/2011 12:10 AM, Fahim M wrote:
Hi
I have a certain number of mysql tables(relation), say 50, some of them
having 5 fields and some with 6 fields. a particular search item may be
found in multiple tables with multiple rows. I am using a loop to find all
those.
My problem is I want to first combine all those results and then find all
the unique entries. (the query results may overlap).
What is the best way to do it?
If you're looking for unique results, do a UNION query for all the
tables. You'll need to add a dummy field for the 5-field tables, and
make sure the field names are the same (use <oldfieldname> AS
<newfieldname> to make sure everything ends up the correct result
column). UNION queries automatically remove duplicates.
Toby
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
