Pre-joining

DocMusher
DocMusher New Altair Community Member
edited November 2024 in Community Q&A
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
Tagged:

Answers

  • JEdward
    JEdward New Altair Community Member
    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.