How to create a view that show all (sales and returns) in one row if the date the same

See more:

MySQL

I have two table (sales_main, sales_sreturned_main) , based on this tables i created two views to group every one of them by (day,weak,month,year).

view_sales_invoices_summery: sales

------------------------------------------------------------------------
smain_Date --- YEAR_smain_Date_ --- (others columns )--- Qunt --- TotalValue -- (others columns )
------------------------------------------------------------------------

view_rsales_invoices_summery: returns sales

------------------------------------------------------------------------
sretmain_Date --- YEAR_sretmain_Date_ --- (others columns )--- Qunt --- TotalValue -- (others columns )
------------------------------------------------------------------------

But how to create a view that show all (sales and returns) in one row if the date the same and zero if there is no data like (Briefly):
if I have this data
Sales

------------------------------------------------------------------------
date ------- Sales Value -- others columns
2021/2/1 --- 3000        --
2021/2/1 --- 2000        --
2021/2/2 --- 3500        -- 
2021/2/2 --- 1500        -- 
2021/2/2 --- 2000        --
------------------------------------------------------------------------

Returns

------------------------------------------------------------------------
date ------- Sales Value -- others columns
2021/2/1 --- 2000        --
2021/2/3 --- 500         --
------------------------------------------------------------------------

i want to show them like :

------------------------------------------------------------------------
date -- year -- month -- weak -- day -- sales Qunt -- Sales Value -- ret.qunt -- ret.value --- 
date1-- 2021 -- 2     -- 1    -- 1   -- 2          -- 5000        -- 1        -- 2000      --- 
date2-- 2021 -- 2     -- 1    -- 2   -- 3          -- 7000        -- 0        -- 0         --- 
date3-- 2021 -- 2     -- 1    -- 3   -- 0          -- 0           -- 1        -- 500         --- 
------------------------------------------------------------------------

What I have tried:

I created the views to group sales table and returns table but I don't how to create one view to group both of them

sales

CREATE OR REPLACE VIEW `view_sales_invoices_summery` AS SELECT 
smain_Date,
YEAR(smain_Date), MONTH(smain_Date), WEEK(smain_Date), DAY(smain_Date),
r_user_ID,
r_branche_ID,
cust_ID,
COUNT(smain_ID) as Qunt,
smain_TotalValue as TotalValue,
smain_ExtraValue as ExtraValue,
smain_DiscValue as DiscValue,
smain_NetValue as NetValue,
smain_PaidValue as PaidValue,
smain_ReminValue as ReminValue,
sTotalProfits as TotalProfits
FROM sales_main
GROUP BY YEAR(smain_Date), MONTH(smain_Date), WEEK(smain_Date), DAY(smain_Date),r_user_ID,
r_branche_ID,
cust_ID,
smain_Date,
TotalValue,
ExtraValue,
DiscValue,
NetValue,
 PaidValue,
ReminValue,
TotalProfits

returns

CREATE OR REPLACE VIEW `view_rsales_invoices_summery` AS SELECT 
	YEAR(sretmain_Date), MONTH(sretmain_Date), WEEK(sretmain_Date), DAY(sretmain_Date),
	sretmain_Date,
    r_user_ID,
r_branche_ID,
vendor_ID,
    COUNT(sretmain_ID) as Qunt,
	sretmain_TotalValue as TotalValue,
	sretmain_ExtraValue as ExtraValue,
	sretmain_DiscValue as DiscValue,
	sretmain_NetValue as NetValue,
	sretmain_PaidValue as PaidValue,
	sretmain_ReminValue as ReminValue
	FROM sales_sreturned_main
	GROUP BY YEAR(sretmain_Date), MONTH(sretmain_Date), WEEK(sretmain_Date), DAY(sretmain_Date),r_user_ID,
r_branche_ID,
vendor_ID,
sretmain_Date,
TotalValue,
ExtraValue,
DiscValue,
NetValue,
 PaidValue,
ReminValue