Search code examples
sqlinner-joindqldocumentum

Documentum Query Language Inner Join

I'm working with DQL queries but don't have access to the EMC resources, and I'm new to development in general with some experience in SQL. I want to do an INNER JOIN between two tables, but can only do a LEFT JOIN for some reason. I've noticed others using a Cartesian join (dm_table_1, dm_table_2)-- is that the syntax for DQL inner join? Thanks for the help.

Solution

  • AHiggins wrote a good answer 

    SELECT *
FROM dm_table1,dm_table2
WHERE dm_table1.id = dm_table2.id

    is the way you implicitly write inner join. This is possible even in older versions of Documentum. However, from version 6.7 above you can use explicitly write LEFT OUTER JOIN too. You can read more details about it under Source lists section in DQL Reference guide available at this link.

    EMC support forums are open and you can find lots of answers there.