You can also do a UNION select. SELECT * FROM TABLE1 UNION SELECT * FROM TABLE2 etc.