下面这是百度百科关于union和left join的用法和解释:
union百度百科解释:https://baike.baidu.com/item/SQL%20UNION?fromModule=lemma_search-box
left join百度百科:https://baike.baidu.com/item/SQL%20LEFT%20JOIN?fromModule=lemma_search-box
这里直接上示例代码:
select
a.TRADE_TYPE ,
a.TXN_TMS ,
a.PAY_TYPE ,
a.PAY_CHANNEL,
a.TXN_NUM ,
a.TXN_AMT ,
a.CUR_STATION,
a.DEV_NODE_ID,
b.STATION_NID ,
b.STATION_NAME_CN
from
((
select
table1.TRADE_TYPE ,
table1.TXN_TMS ,
table1.PAY_TYPE ,
table1.PAY_CHANNEL,
table1.TXN_NUM ,
table1.TXN_AMT ,
table1.CUR_STATION,
table1.DEV_NODE_ID
from table1)
union all
( select
table2.TRADE_TYPE ,
table2.TXN_TMS ,
table2.PAY_TYPE ,
table2.PAY_CHANNEL ,
table2.TXN_NUM ,
table2.TXN_AMT ,
table2.CUR_STATION ,
table2.DEV_NODE_ID
from table2)
union all
( select
table3.TRADE_TYPE ,
table3.TXN_TMS ,
table3.PAY_TYPE ,
table3.PAY_CHANNEL ,
table3.TXN_NUM ,
table3.TXN_AMT ,
table3.CUR_STATION ,
table3.DEV_NODE_ID
from table3)
union all
(select
table4.TRADE_TYPE ,
table4.TXN_TMS ,
table4.PAY_TYPE ,
table4.PAY_CHANNEL ,
table4.TXN_NUM ,
table4.TXN_AMT ,
table4.CUR_STATION ,
table4.DEV_NODE_ID
from table4))
as a left join table5 as b
on
b.STATION_NID = a.CUR_STATION
这里是查询了5张表,4张联合查询加一个左连接,用法在代码里应该能清晰了解了,有问题或者有什么错误,欢迎大家评论指正!!!