JOIN SQL. Combining rows from two or more tables based on a shared column between them is done with a JOIN clause. Note that the “CustomerID” in the “Customers” record is the referenced “CustomerID” in the “Orders” table. The “CustomerID” field indicates the association between the two tables above.