SQL Query for Offline & Online sales table.

Question

I have 2 tables as shown below Table 1 and Table -2

I need an output as shown below by joining Table-1 and Table-2

Please help in getting join Query in SQL.

Answer 1

SELECT isnull(a.Date, b.Date) AS Date, isnull(a.ID, b.ID) AS id, isnull(a.area, b.Area) AS area, a."Sales - Store", b."Sales - Online"
FROM  table_1 a
FULL JOIN table_2 b ON a.Date = b.Date
                   AND a.ID = b.ID
                   AND a.area = b.area