View Single Post
  #4 (permalink)  
Old 10-19-2007, 04:17 PM
rgcote rgcote is offline
WebProWorld New Member
 

Join Date: Sep 2005
Posts: 6
rgcote RepRank 0
Default Re: How to Query 2 Tables (Not a join?)

Hmmm. Why do you need all those tables? If the structure is the same between all the tables, then maybe you'll have an easier time by combining all the data into a single table and add an additional field that marks each record as "A", "B", "C", etc.

I am assuming that you put them in different tables because you need to track the records in each table separate from the records in the other tables. If that is the case, then combining them into a single table and tagging them appopriately might be a better way to go.
Reply With Quote