Documentum Query Language Inner Join

Question

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.

Answer 1

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.

Answer 2

I don't have any specific understanding of Documentum, but in most SQL languages when you use a comma-style JOIN, you generally add the 'JOIN condition' to the WHERE clause.

So, you'd use

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