I am trying to come up with a select statement to grab information from 2 identical (apart from table name) tables and output them in an ordered list. For example:
ID | Type | Date_Found
1 | Cat | 01/02/2006
2 | Dog | 09/06/2006
3 | Cat | 11/08/2006
1 | Hamster | 02/01/2006
2 | Snake | 04/05/2007
Now i could do 2 seperate select statements but then record 1 of table2 is going to be the 4th record when it should be the first.
Can anyone suggest how I might do this? Cheers in advance!