I need help writing HQL query for the following scenerio:

I have an object Booking which contains People in it. I want to find if a booking contains atleast one person from another booking:

Booking A - {John, Mary, Jane}
Booking B - {Mary, Henry, Joe}

- The return should be a count of 1, because Booking A has Mary and Booking B also has Mary.

[quote="dawuad"]I need help writing HQL query for the following scenerio:

I have an object Booking which contains People in it. I want to find if a booking contains atleast one person from another booking:

Booking A - {John, Mary, Jane}
Booking B - {Mary, Henry, Joe}

- The return should be a count of 1, because Booking A has Mary and Booking B also has Mary.[/quote]

Hello Friend:

Try this:

select a.person.name From Booking A where
a.person.name in (select b.person.name from Booking B).


requests for comments.

Thank you for your reply, however the only problem is that the Booking A contains more than one person, meaning that the Booking has a collection of people, so it would not be b.person rather it would be b.personset.person.name which I don't really think it would work!

[quote="dawuad"][quote="neketsushonen"]
Hello Friend:

Try this:

select a.person.name From Booking A where
a.person.name in (select b.person.name from Booking B).


requests for comments.[/quote]

Thank you for your reply, however the only problem is that the Booking A contains more than one person, meaning that the Booking has a collection of people, so it would not be b.person rather it would be b.personset.person.name which I don't really think it would work![/quote]


You are rigth... i have ignore that point...

You problem is very interest. I have to think a lot too...

I have a worst solution:

do it with JAVA HashMap...

Hehe...

How about something like this?