合并两个select语句中的列 [英] Combining columns from two select statement

问题描述

大家好，
我需要结合两个单独的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语句中的列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！