SQL for joining two tables

You will be joining the two tables on one or more columns. In Oracle, I can code the join operation similar to the following:

SELECT tableA.columnA, tableA.columnB, tableB.columnX, tableB.columnY
FROM tableA, tableB
WHERE tableA.columnA = tableB.columnX AND tableA.columnB = tableB.columnY;

In the same above, the rows from the two tables are joined where ColumnA = ColumnX and ColumnB = ColumnY. You can code any join condition this way. Oracle also supports the ANSI SQL standard join syntax. The above query in ANSI SQL standard would look like the following:

SELECT tableA.columnA, tableA.columnB, tableB.columnX, tableB.columnY
FROM tableA INNER JOIN tableB
ON tableA.columnA = tableB.columnX AND tableA.columnB = tableB.columnY;