If you're using SQL the format of the join code is pretty straightforward
SELECT * FROM /* This selects all columns */ table1 INNER JOIN table2 /* Use LEFT JOIN or RIGHT JOIN if needed. ON table1.key1 = table2.key2 /* here you put in your key joins, use AND or OR to separate out different join rules. INNER JOIN table3 /* Use LEFT JOIN or RIGHT JOIN if needed. ON table1.key1 = table3.key2 /* You can also join to table2 if needed.
This is standard SQL so the same query would work on Oracle, SQL Server, MySQL, PostgreSQL as you choose.
Answers
SELECT * FROM /* This selects all columns */
table1
INNER JOIN table2 /* Use LEFT JOIN or RIGHT JOIN if needed.
ON table1.key1 = table2.key2 /* here you put in your key joins, use AND or OR to separate out different join rules.
INNER JOIN table3 /* Use LEFT JOIN or RIGHT JOIN if needed.
ON table1.key1 = table3.key2 /* You can also join to table2 if needed.
This is standard SQL so the same query would work on Oracle, SQL Server, MySQL, PostgreSQL as you choose.