UNION ALL
SELECT * FROM TABLE1 UNION ALL SELECT * FROM TABLE2
select T1.*,T2.* from tableT1,Table2 T2 or select * from table1 union all select * from table2 or select Field1 from table1 union select field2 from table2
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)