raven90
(강도욱)
|
|
select A.일자, A.번호,
B.창고 as 창고1,
C.창고 as 창고2,
A.수량 from demo1 as A
left join (select 일자,번호,창고 from demo1 where 창고 in ('일산','서울')) B on A.일자=B.일자 and A.번호=B.번호
left join (select 일자,번호,창고 from demo1 where 창고 in ('파주','인천')) C on A.일자=C.일자 and A.번호=C.번호
group by A.일자, A.번호, A.수량, B.창고,C.창고
2020-01-12 오전 1:33:56
|
|
