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.