Hello,

I'm writing part of turist blog so I have two entities: place and
photo in relation 1 to many, so every place can have multiple photos,
but single photo belongs to one place.

How following SQL query rewrite in QueryOver:

SELECT  min(id)
FROM photo
where id in (... it doesn't matter what's here ...)
group by place_id

photo table contains following columns:
- id (pk),
- place_id (fk to 'place' table)
- label
- date added
etc (not relevant)

So I want only list of photo ids (only outputed column) and this query
will be used as subquery in another queryover.
Can it be done by QueryOver syntax?

--
Regards,
 Macko

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