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 the 5 most recently added results of which companydate holds the value. Currently my code reads ..... SELECT disc_id, companyname, companyurl, companydate FROM table_1, table_2, table_3, table_4 ORDER BY companydate LIMIT 5 Any help would be appreciated. thanks in advance, Mark Beauman