I'm looking to create a Left outer join Nhibernate query with multiple on statements akin to this:
SELECT * FROM [Database].[dbo].[Posts] p LEFT JOIN [Database].[dbo].[PostInteractions] i
ON p.PostId = i.PostID_TargetPost And i.UserID_ActingUser = 202
I've been fooling around with the critera and aliases, but I haven't had any luck figuring out how do to this. Any suggestions?