Hi,

I need help on a basic question. I have 2 tables and i m fetching records by joing the tables using HQL. I have set the relationship in the mapping files. My question is if there is no physical relationship set(foreign key is not set) in the oracle tables, will my HQL work??
Please clarify.

Thanks,
PK

Yes. If you mapped the relationship in your mapping (hbm, annotations, jpa, or else).

If it's not mapped, then just use a theta-style join (say where local_id=foreign_id).