Dynamic Query for Two tables

[8年前 に Meera Prince によって更新されました。]

Hi ALL

How can we make inner join between two table using liferay dynamic query API and some table might not have model class then how can we create dynamic query for them
Example
assetentry and assetentries_assetcategories When we crate dynamic query it always expect model call to create it so please let me know if any one have examples regarding to this scenario

Regards,
Meera Prince

[8年前 に Ravi Kumar Gupta によって更新されました。]

Meera,

Is Custom SQL not an option to implement and use here?

[8年前 に Meera Prince によって更新されました。]

HI
Ok thank you .. but it should also work for those type of scenarios too I think otherwise again we need to go for custom sql. anyway thank you very much for your information.

Regards,
Meera Prince