Hello, I'm new to the Hibernate world and havent much info on how to do left joins using QueryOver. I'm trying to convert to following over to QueryOver. Thanks in advance.
select CommunicationMaster.CommunicationID as CommunicationID, Staff.StaffID as StaffID, CommunicationDetail.Status as Status from dbo.[shr_PC_Communication] CommunicationMaster inner join dbo.[shr_PC_Communication_Detail] CommunicationDetail on CommunicationMaster.CommunicationID=CommunicationDetail.CommunicationID left outer join dbo.[shr_Staffs] Staff on CommunicationDetail.StaffID=Staff.StaffID where ( CommunicationMaster.Created_Date between @p0 and @p1 ) and ( CommunicationMaster.IsRemoved is null ) and ( CommunicationDetail.IsArchived is null ) and ( CommunicationDetail.Status in ( @p3 ) ) and ( Staff.StaffID in ( @p4 ) );
|