My question really is can I use this kind of syntax with hql from Lecture l1 inner join Lecture l2 on l1.Time = l2.Time
Or from Lecture l1, (select Time from Lecture) l2 where l1.Time = l2.Time My goal is to learn if I can use the between operator without having to specify the subquery twice like this: from Lecture l1 where l1.Time between (select max(Time) from Lecture) and (select max (Time) from Lecture) These are really silly examples to keep it simple :) On 18 Juni, 23:17, cws <[email protected]> wrote: > I was thinking that the parser would allow it? > > On 18 Juni, 22:45, cws <[email protected]> wrote: > > > Hi! > > > I can't do something like this with hql can i? > > > from Lecture outerLektion > > inner join (select DateOnly(l.Time) as date > > from Lecture l > > where outerLektion.Time = l.Time and l.Time between :StartDate > > and :EndDate > > group by DateOnly(l.Time) > > having minute((max(l.Time + minute(l.Length)) - min(l.Time)))> 7) > > as innerLektion > > > on outerLektion.Time between innerLektion.date and innerLektion.date > > > mappings > > herehttp://groups.google.com/group/nhusers/browse_thread/thread/fd686b51a... > > > Regards --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
