Given an Employee class, with a collection property Phones, is it possible to do queries like the folllowing in HQL?

1. Select employees and their primary phone

??? ideally something like

SELECT e.FullName, p.PhoneNumber
FROM Employee AS e
JOIN e.Phones[?] AS p ON p.IsPrimary = true

2. Select employees and their "first" cell phone

??? ideally something like

SELECT e.FullName, p.PhoneNumber
FROM Employee AS e
JOIN e.Phones[?] AS p ON p.PhoneType = 'CELL' HAVING MIN(p.Index)

OK, with a little experimenting, the 1st case can be done as

SELECT e.FullName, p.PhoneNumber
FROM Employee AS e
LEFT JOIN e.Phones AS p
WHERE p.IsPrimary = true

It's a little odd that you join to the collection when you really mean one of its members, but it works. Too bad you can't leave out the verbose JOIN and just do

SELECT e.FullName, e.Phones.PhoneNumber ...

I still have no idea how to do the 2nd case. Can someone point me to examples of using HQL's "collection expressions", i.e.
{ some, exists, all, any }
I picked up the book Pro Hibernate 3, which mentions them, but no details or examples are given :(

Maybe use a subselect with a TOP 1 for the Phone Id?

I went to the (Java) Hibernate site and got their Hibernate 2.1.7 reference manual. That has the "official" documentation for HQL, and helped a lot. I assume NHibernate essentially supports whatever's in Hibernate 2.1.7 as far as HQL syntax goes ...