I have two tables with the same column I need to select the data for both columns in one query and return all rows
Iv'e read loads of stuff but don't know how to write the query
Anyone know
select c1 from t1 union all select c1 from t2
Note that that does not work for MySQL <4.0
Im looking for a query that will work on all MySQL versions
I don't know if iv'e got to use joins or what... im really lost
