Search results

I'm trying to run a query which may have duplicate records, but different dates. I want to be able to compare new tables with the master table so it only looks at the most recent date to see if any changes took place. This is what I have so far, but still doesn't return what I would like...

SELECT* FROM test2 INNER JOIN test1 ON test2.Unique = test1.Unique WHERE test2.Day = (Select Max(test1.Day)) AND test2.Ex8<>test1.Ex8; - Getting a Syntax Error in my WHERE statement, can anyone point me in the right direction. Relatively new to SQL coding.