合并两个select语句中的列

问题描述：

大家好，
我需要结合两个单独的select语句的列/结果，我该怎么做...请帮助....
谢谢"

Hi every one,
I need to combine columns/results of two separate select statement, how can i do so plz help ....
"Thanking you"

答

很难找到您需要的东西.
UNION ALL将添加从每个语句接收到的行，例如

Hard to find out what you need.
A UNION ALL will add the rows received from each statement, e.g.

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

合并两个select语句中的列

相关推荐