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 the error Starts, so even though it gives us a portion of the SQL statement that is very long, look at the start of the snippet it gives us. The SQL snippet starts with the keyword ‘DISTINCT’.
Why doesn’t Access like the keyword DISTINCT? It’s definitely part of the SQL language.
This question was asked on Jan 10, 2013.
Recently Asked Questions
- Please refer to the attachment to answer this question. This question was created from Medieval Period and Ballads.
- Please refer to the attachment to answer this question. This question was created from Test.