Pre-joining

DocMusher
New Altair Community Member
Hi,
How can I pre-join more than 2 tables in read database query?
Is somebody using a psql visual query builder within RM?
Sven
How can I pre-join more than 2 tables in read database query?
Is somebody using a psql visual query builder within RM?
Sven
Tagged:
0
Answers
-
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.
0