SELECT Offices.Name, Cities.Name FROM Offices LEFT OUTER JOIN Cities ON Offices.City_id=Cities.City_id;

SELECT Offices.Name, Cities.Name FROM Offices INNER JOIN Cities ON Offices.City_id=Cities.City_id;

SELECT Offices.Name, Cities.Name FROM Offices RIGHT OUTER JOIN Cities ON Offices.City_id=Cities.City_id;

SELECT Offices.Name, Cities.Name FROM Offices CROSS JOIN Cities

SELECT Offices.Name, Cities.Name FROM Offices FULL OUTER JOIN Cities ON Offices.City_id=Cities.City_id;

"WHERE” is always used after “GROUP BY” and “HAVING”

before “GROUP BY”

"WHERE” is always used before “GROUP BY” and HAVING

after “GROUP BY”

“WHERE” is used to filter groups but “HAVING” is used

to filter rows

“WHERE” is used to filter rows but “HAVING” is used to

filter groups