Hi Plen,

Try
IQuery iq = querySession.CreateQuery("select src from RptDocumentBase src
where
src.RptDocumentCore in (select srcc.DocCoreId from RptDocumentCore
srcc where contains(srcc.Body, 'florida')>0")

this should return a List of RptocumentBase object.



On Wed, Aug 17, 2011 at 1:18 AM, PLen <petera...@earthlink.net> wrote:

> I may have simplified my query too much in the above question.  What I
> really have is a query that looks like:
>
> IQuery iq = querySession.CreateQuery("from RptDocumentBase src where
> src.RptDocumentCore in (select srcc.DocCoreId from RptDocumentCore
> srcc where contains(srcc.Body, 'florida')>0")
>
> So there is actually a join of two tables in the query (I want
> RptDocumentBase objects back based on a 'contains' query in the
> RptDocumentCore table).
>
> --
> You received this message because you are subscribed to the Google Groups
> "nhusers" group.
> To post to this group, send email to nhusers@googlegroups.com.
> To unsubscribe from this group, send email to
> nhusers+unsubscr...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/nhusers?hl=en.
>
>


-- 
Jack Xu
Best Regards

-- 
You received this message because you are subscribed to the Google Groups 
"nhusers" group.
To post to this group, send email to nhusers@googlegroups.com.
To unsubscribe from this group, send email to 
nhusers+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/nhusers?hl=en.

Reply via email to