posted 13 years ago
Hi,
I have a Query on 2 tables A,B as below:
This query is returning correct result on Database.
select A.id, B.id from Apple A left join Ball B on A.id= B.aId where A.categoryId = 23 order by B.phone ;
In Database, for each category, We have many records in A table. And corresponding to each entry in A table, We may/may not have a unique entry in table B.
Need to fetch all records that are in A and are associated/not associated with Table B for that categoryId. When we do not find any record for B, make it as blank/null. Basically I want distinct entry left outer join.
When I am using it in Hibernate Criteria Class, on keyword is not recognized. And so not able to use it. Please suggest a way out to implement it.
Thanks.