Sunday, March 2, 2014

Help with Converting an Access query



select L_Month, L_MonthName FROM tbl_Month Mth
WHERE NOT EXISTS
(SELECT 1 FROM tbl_SignOff Sgn
WHERE Sgn.SO_Month = Mth.L_Month
AND Sgn.SO_Year = @YearVar
AND Sgn.SO_Location = @UserLoc)





For every expert, there is an equal and opposite expert. - Becker's Law





My blog




My TechNet articles



No comments:

Post a Comment