資料庫大佬們，用sql陳述句怎么實作把表a和表b合并成表c啊
uj5u.com熱心網友回復：
1,select a.field1,a.field2,a.field3,a.field4,a.field5,b.field6,b.field7
from a full outer join b
on a.field3=b.field3 and a.field4=b.field4 and a.field5=b.field5
2,
select a.field1,a.field2,a.field3,a.field4,a.field5,'' field6, '' field7
from a
union all
select '' field1,'' field2,b.field3,b.field4,b.field5,b.field6,b.field7
from b
uj5u.com熱心網友回復：
已成功，感謝大佬轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/8505.html
標籤：開發
下一篇：ORACLE 存盤程序輸出結果