Re: How to Query 2 Tables (Not a join?)
"The reason I have so many tables with all the same fields is that eventually (future expansion) after some growth, these tables will have fields added that are NOT the same."
A structure that might work for you is to move all the common fields onto a base table and only have the custom fields in the separate tables (a,b,c). You can then do the single query for your random search while still allowing you to customise each type. e.g.
#searching just a
select * from a, base where a.baseid = base.id ...
# searching all
select * from base ...
|