Question
SELECT VERSION
FROM STOVE, STOVE_REPAIR
WHERE DISTINCT STOVE.Type = 'Maytag' AND
STOVE.SerialNumber = STOVE_REPAIR.SerialNumber;
Gave a pop-up error that said:
Syntax error (missing operator) in query expression ‘DISTINCT STOVE>type = ‘Maytag' AND STOVE.SerialNumber = STOVE_REPAIR.SerialNumber'
The error tells us where error Starts, so even though it gives us a portion of SQL statement that is very long, look at start of the snippet it gives us. The SQL snippet starts with keyword ‘DISTINCT'.
Why doesn't Access like keyword DISTINCT? It's definitely part of the SQL language.