How to add filter in left join like follows using ICriteria

jophymaliakal · **Joined:** Thu Dec 04, 2008 9:50 am **Posts:** 1

SELECT M.PURMaterialID, M.Material, MT.PURMaterialTreeID, MT.COMCompanyID, EMC.ESTEstimationMaterialCoefficientID, EMC.DirectEstimateFlag
FROM PURMaterial AS M
INNER JOIN PURMaterialTree AS MT ON M.PURMaterialID = MT.PURMaterialID
LEFT OUTER JOIN ESTEstimationMaterialCoefficient AS EMC ON
M.PURMaterialID = EMC.PURMaterialID AND EMC.DirectEstimateFlag = 1

Please help me..

wolli · **Posted:** Sat Dec 06, 2008 5:29 am

Afaik, that's not possible right now. But there's a JIRA issue open:

http://jira.nhibernate.org/browse/NH-514?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17224#action_17224