我正在尝试在SQL Server中合并2个表
表格1: SO
ItemCode | SONumber| SODate | SOQTY
-------------------------------------------
TBJ182-01-02 | 0005251 | 29/01/2014 | 5
TBJ184-01-02 | 0005251 | 29/01/2014 | 2
TBJ182-01-02 | 0005554 | 15/02/2014 | 4
TBJ185-01-02 | 0005554 | 15/02/2014 | 5
表2: PO
ItemCode | PONumber| PODate | POQTY
--------------------------------------------
TBJ182-01-02 | 0009105 | 11/02/2014 | 8
TBJ184-01-02 | 0009208 | 14/02/2014 | 5
TBJ189-01-02 | 0009208 | 14/02/2014 | 5
结果表:
ItemCode | SONumber| SODate | SOQTY | PONmber |PODate | POQTY
-------------------------------------------------------------------------
TBJ182-01-02 | 0005251 | 29/01/2014| 5 | | |
TBJ184-01-02 | 0005251 | 29/01/2014| 2 | | |
TBJ182-01-02 | 0005554 | 15/02/2014| 4 | | |
TBJ185-01-02 | 0005554 | 15/02/2014| 5 | | |
TBJ182-01-02 | | | | 0009105 | 11/02/2014 | 8
TBJ184-01-02 | | | | 0009208 | 14/02/2014 | 5
TBJ189-01-02 | | | | 0009208 | 14/02/2014 | 5
你能帮忙吗?
您可以通过以下full outer join
一些技巧最轻松地做到这一点:
select coalesce(SO.ItemCode, PO.ItemCode) as ItemCode,
SO.SONumber, SO.SODate, SO.SOQTY,
PO.PONmber, PO.PODate, PO.POQTY
from SO full outer join
PO
on 1 = 0;
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句