Is it possible to do a left join like this in Nhibernate:
SELECT T.title_id, T.title, S.qty
FROM titles T
LEFT JOIN sales S on
    T.title_id = S.title_id
    AND S.stor_id = '7131'
ORDER BY T.title
The important par开发者_开发技巧t to note is the extra clause (AND S.stor_id = '7131') in the LEFT JOIN expression.
Can I do this in Nhibernate hql or is there another way?
The answer is the with keyword, for example:
Select q FROM GeneralQuestion 
q Left Join q.QuestionResponses as qr with 
qr.ContactUid = :contactuid WHERE q.ParentUid = :audituid
 
         
                                         
                                         
                                         
                                        ![Interactive visualization of a graph in python [closed]](https://www.devze.com/res/2023/04-10/09/92d32fe8c0d22fb96bd6f6e8b7d1f457.gif) 
                                         
                                         
                                         
                                         加载中,请稍侯......
 加载中,请稍侯......
      
精彩评论