Regarding usage of inner joins in EJBs

Hi All,

I have a requirement to return an object which contains two tables results.In general in Database we do this by the help of innerjoins concept.Is EJB QL supports joins concept.If it supports how it is possible to write a query on two entity beans.

I am using SAP NetWeaver Developer Studio IDE for developing EJBs.

Any one guide me in this issue.

Thanks & Regards

Madhu.