Greetings: I have a series of large tables. 5+gb each. They have identical structures.
Sample of the query I want to run: select ref.zipcodes.state as state, count(1) as count from BIGTABLE,BIGTABLE2,BIGTABLE3,ref.zipcodes where tsb between $Start and $End and zipcode=ref.zipcodes.zipcode group by state order by count DESC limit 10 This query references a small table (ref.zipcodes), which is not the same structure. I, of course, run into ambiguity issues... Any ideas around this? It has to be a dynamic, efficient solution... Thanks P -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]