left join where null

montoyam

what is the correct syntax for when you want the right side to be null (no record).

I tried this but it didn't work:

.LeftJoin("FundOrgDeptGroup_Detail", "FundOrgDeptGroup_Detail.Org", "=", "FundOrgDeptGroup_Detail.Org")
.Where("FundOrgDeptGroup_Detail.Org", null)

montoyam

oops.. nevermind. It does work, I just put the table on the left and right in the first line. my bad.

                    .LeftJoin("FundOrgDeptGroup_Detail", "FundOrgFTE_Import.Org", "=", "FundOrgDeptGroup_Detail.Org")
                    .Where("FundOrgDeptGroup_Detail.Org", null)