Table Join

[asknyldz]

Hi All,

Below script result show as;

Product	Order	Sales
a	100	90
b	200	210
-	0	50

But i need to see this, how can i join these two tables?

Product	Order	Sales
a	100	90
b	200	260

My Script is;

Table a:
Load
Location, Product, Order
x, a, 100
y, b, 200

Table b:
Load
Location, Product, Sales
x, a, 90
y, b, 210
z, b, 50

[Nicole-Smith · Accepted solution]

I think this should work:

TableA:
Load Location, Product, Order
From YourTable1;

LEFT JOIN (TableA)
Load Location, Product, sum(Sales) as Sales
From YourTable2
Group by Location,Product;