Refresher/SQL/Most Frequently Asked

Presentation
Inner join: intersection, e.g. SELECT Person.LastName, Person.FirstName, Sales.OrderNo FROM Person INNER JOIN Sales ON Person.P_Id=Sales.P_Id ORDER BY Person.LastName Outer join: union, e.g. Foreign key: primary key of another table.

Mobile version