[MySQL] PGS - 오프라인/온라인 판매 데이터 통합하기

https://school.programmers.co.kr/learn/courses/30/lessons/131537

프로그래머스

select date_format(sales_date,'%Y-%m-%d') as SALES_DATE, PRODUCT_ID, USER_ID, SALES_AMOUNT
FROM ONLINE_SALE
WHERE YEAR(sales_date)=2022 and MONTH(sales_date)=3

union all
select date_format(sales_date,'%Y-%m-%d') as SALES_DATE, PRODUCT_ID, NULL AS USER_ID, SALES_AMOUNT
FROM OFFLINE_SALE
WHERE sales_date>='2022-03-01' and sales_date<='2022-03-31'

order by SALES_DATE, PRODUCT_ID, USER_ID;

 

• UNION ALL

https://tech-heng.tistory.com/71

[MySQL] UNION ALL