Repeating attribute in Select Query with Join

Hi experts,

I'm trying to write a DQL where in I need r_version_label in select statement along with other attributes, I'm also using a join with other object type hence getting exception DM_QUERY2_E_REPEAT_TYPE_JOIN. I know I can't put repeating attribute in select while using joins. But i guess there is some way we can do it.

Could any one suggest how I can get it.

The below is sample of query I'm using

select distinct(p.object_name) as DocumentID, p.r_version_label from a_type p, b_type b where p.doc_unit like '%abcd%' and any p.q_elements = b.title and p.doc_language = b.by_lang and any p.bayer_keywords= '002100'