Since the beginning of learning SQL Server I'm pretty much confused with JOIN conditions that defines the way two tables are related in a query by: Specifying the column from each table to be used for the join. A typical join condition specifies a foreign key from one table and its associated key in the other table. Specifying a logical operator ...