What about this one with a WHERE clause:
SELECT TBL_MONTH.L_Month, TBL_MONTH.L_MonthName
FROM TBL_MONTH LEFT JOIN TBL_SIGNOFF ON TBL_MONTH.L_Month = TBL_SIGNOFF.SO_Month
AND TBL_SIGNOFF.SO_YEAR=@cboyear AND TBL_SIGNOFF.SO_LOCATION=@tmpVarUserLOC
WHERE TBL_SIGNOFF.SO_Month IS NULL;
Thank you very much. That also works as well.
Appreciate all the help everyone.
No comments:
Post a Comment