How can I Join 2 tabels ?

I have two tables having identical columns. I want to display a list of all the records in the two tables. Is there a SQL command I can use ? (like UNION)

Since MySQL doesn't yet support UNION, I found that I have to do a bit of fakery to accomplish this. I create a third table with the same attributes as the first two tables. Then issue "insert into table3 select * from table1;" and "insert into table3 select * from table2;". Then "select * from table3;" gives me all of the records.

Don