PHV, I'm getting the two suggestions mixed up in terms of what I am suppose to do. Do I do a normal join and then do the filtering your suggesting? I did the following and of course received an error:
SELECT [AUDIT REVIEWS].[FYE 2000], [dbo_localUnitAudit].AuditReceivedDate, [AUDIT REVIEWS].[DATE COMPLETED], [AUDIT REVIEWS].CountyCd, [AUDIT REVIEWS].LocalUnitType, [AUDIT REVIEWS].LocalUnitCd
FROM [AUDIT REVIEWS]
INNER JOIN [audit reviews].[countycd] = [dbo_localunitaudit], [audit reviews].localunittype=[dbo_localunitaudit].localunittype, [audit reviews].localunitcd = [dbo_localunitaudit].localunitcd
WHERE Right([Audit reviews].[fye 2000],4) = dbo_localunitaudit.fiscalyear;