Join Query with Custom Aspects ?

[dark_rider]

How could I perform to join custom aspects with cmis query?
this sql statement is working:  SELECT D.*, O.* FROM cmis:document AS D JOIN cmwnable AS O ON D.cmisbjectId = O.cmisbjectId
But when the tables are our custom apects, it is not working. Is there any way to join them?

[andy]

Hi

As far as I understand it, custom aspects should be available to the CMIS data model and anything that extemds content and folder. What happens? Do you get an error or no results?
If the type or property is unknown it should throw an error at query time (try an unknown aspect or type).

So to get any further you need to provide:
1) Some basic details of the aspect and properties it holds (thier types etc)
2) the query
3) a desciption of why it does not work - error no results
4) if you get no results, confirm the node has the aspect you expect and the properties you expect
5) Check you can do what you want.
    Alfresco only supports self joining to aspects on the objects selected in the type (not a real join) - it allows you to make available the additional properties on the nodes pulled back
    Each row in the results set only represents one node, not more.

Andy