Error in SQL Query
Posted on 2016-11-29
I'm trying to create an SQL query that will find unmatched records using 2 table. Here is the query,
SELECT TblAdpClean.[Last Name], TblAdpClean.[First Name], TblAdpClean.[Worked Department], TblAdpClean.[Pay Code], TblAdpClean.Hours, TblAdpClean.EmpID, TblTWClean.DeptName
FROM TblAdpClean LEFT JOIN TblTWClean ON TblAdpClean.[EmpID] = TblTWClean.[EmpID]
WHERE (((TblTWClean.DeptName)<>(TblADPClean.Worked Department));
The error I'm getting is Syntax error (missing operator) in query expression "(((TblTWClean.DeptName)<>(TblADPClean.Worked Department));"