An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
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.
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.