1
2
3
4
5
6
7
8
| SELECT date_format(sales_date, "%Y-%m-%d") as sales_date, product_id, user_id, sales_amount
from online_sale
where sales_date >= "2022-03-01"
union
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"
order by sales_date asc, product_id asc, user_id asc;
|