[nhusers] Re: Can HQL join subqueries?

There was only one column in the IN clause, when I have to match with multiple column, in SQL I use join with ON clause " ON a.x=b.x and a.y=b.y) Is it possible in HQL also ? On Monday, November 24, 2008 at 9:56:02 AM UTC+5:30, marducci wrote: > > Can someone please help me turn the following

[nhusers] HQL Hibernate INNER JOIN SUBQuery

I have some experience in SQL, but my knowledge in HQL is limited Here is my SQL query select * from (select * from readings join (select max(signal) as signal,sender as mac ,receiver as rc from readings where created_datetime between '2018-02-05 10:25:52' AND '2018-04-05