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.
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.