selecting rows from several tables with same column names BUT not joined

2004-03-06 Thread Mark Beauman
I have 15 tables, all with the same column names (but different values) where i want to SELECT all rows over all tables but not to JOIN. Is there a way i can do this? I am sure I am missing something simple but cannot seem to find the answer in the manual, forums. Furthermore i want to read

Re: selecting rows from several tables with same column names BUT not joined

2004-03-06 Thread Paul DuBois
At 12:57 +1100 3/7/04, Mark Beauman wrote: I have 15 tables, all with the same column names (but different values) where i want to SELECT all rows over all tables but not to JOIN. Is there a way i can do this? I am sure I am missing something simple but cannot seem to find the answer in the