SQL INNER JOIN

1. Inner Join

SELECT A1.Store_Name STORE, SUM(A2.Sales) SALES 
FROM Geography A1 
INNER JOIN Store_Information A2 
ON A1.Store_Name = A2.Store_Name 
GROUP BY A1.Store_Name;

2.     Outer Join

SELECT A1.Store_Name, SUM(A2.Sales) SALES
FROM Geography A1, Store_Information A2
WHERE A1.Store_Name = A2.Store_Name (+)
GROUP BY A1.Store_Name; 

Tweet

Berlangganan: