In this case just do not use Criteria. Why do you need to? fedor.
------------------------------- The Joy of CVS > -----Original Message----- > From: Nick Pomfret [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 30, 2001 10:02 AM > To: Turbine Users List > Subject: criteria hell > > > Can someone please help me turn this SQL into a Criteria object? > > select > x.id, > max(x.some_column) > from > table_x x, > table_y y, > where > (y.blah < x.blah > or y.blah is null ) > and x.id = y.id > group by > x.id; > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
