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 here
http://groups.google.com/group/nhusers/browse_thread/thread/fd686b51a34f9c31/b070d931ef5ac700#b070d931ef5ac700

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
-~----------~----~----~----~------~----~------~--~---

Reply via email to