select 產品編號,異代,單據編號,項次,客戶簡稱(空白),等級,sum(入庫件數),sum(入庫數量),sum(出庫件數),sum(出庫數量) from (select 產品編號,異代,單據編號,項次,客戶簡稱(空白),等級,入庫件數,入庫數量,0 as 出庫件數,0 as 出庫數量 from 表1 union all select 產品編號,異代,單據編號,項次,客戶簡稱(空白),等級,0 as 入庫件數,0 as 入庫數量, 出庫件數, 出庫數量 表2) group by 產品編號,異代,單據編號,項次,客戶簡稱(空白),等級
產品編號,異代,單據編號,項次,客戶簡稱(空白),等級,入庫件數,入庫數量,0 as 出庫件數,0 as 出庫數量 from 表1
union all
select
產品編號,異代,單據編號,項次,客戶簡稱(空白),等級,0 as 入庫件數,0 as 入庫數量, 出庫件數, 出庫數量 表2)
group by 產品編號,異代,單據編號,項次,客戶簡稱(空白),等級