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.

score 4 · Accepted Answer · edited May 23 '17 at 12:30

4

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.

edited May 23 '17 at 12:30

Community

1
1

answered Aug 12 '14 at 20:37

Miki

2,493
2
27
39

Thanks for the links! I've seen some of the EMC support forums before via google searches, but I didn't realize they own and support Documentum. – GoldAnchor Aug 14 '14 at 18:26

score 3 · Answer 2 · edited May 23 '17 at 11:58

3

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

edited May 23 '17 at 11:58

Community

1
1

answered Aug 12 '14 at 17:19

AHiggins

7,029
6
36
54

thanks! found out that DQL does not have inner join, and this is the only way to mimic the same functionality. – GoldAnchor Aug 12 '14 at 18:02

Documentum Query Language Inner Join

2 Answers2