Hi ,

I am using Criteria.



I have 2 table .suppose say Table A and table B .

Table A has id1 and Table B has id2 . And TableB has association with Table A(many-one Association).

In the Criteria How can I compare 2 table from id1 Table A to id2 Table B .


Query as follows :

select * from TableA a,TableB b where a.id1 = b.id2.

how can I write the above query in Criteria.

plzzz help it is too urgent.

Official documentation related to Criteria and Example queries should be able to help you out.
e.g.
http://hibernate.org/hib_docs/v3/refere ... mples.html

Hi Ravi,

Thx for ur replay Ravi .

It does not match with my requirment.

We need to give assocation in hbm file, ofcourse we ought be.

I would like to compare 2 objects say A.id1 = B.id2

A is Tabl1A and B is TableB.

I did not find in the like u provided.,

Please if u know more about post me ............

Thanks in Advance.