Sunday, March 2, 2014

Help with Converting an Access query

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;


No comments:

Post a Comment