Hi All,
I’m trying to build ONE query to get unmatch record in two tables (table A and table B).
Both table have same structure just three filed ( SaleID, Product and Profit)
SalesID – Duplicate
Product – duplicate
Profit - Currency
Here what query Should Do:
Group three fields for both table (SaleID, Product and Profit (SUM)
And give record which doesn’t match for both tables.