Many people are confused by various JOIN operations supported by SQL. Learn to master the SQL command line with this crash course in JOIN syntax.

Here's two examples of what I am talking about (example 1 and 3 achieve the same end result on tableA as per my understanding of SQL joins): ...

In this example, two large DBMS tables, TABLE1 and TABLE2, have a column named DEPTNO. An inner join of these tables is performed where the DEPTNO value in TABLE1 is equal to the DEPTNO value in ...