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.
Recently Asked Questions
- I need help with parameterization in multiple scenarios. This is Cal 3 involving line integrals. A straight line segment in the plane from (1,1) to (2,4) The
- Please refer to the attachment to answer this question. This question was created from SUA Word. Additional comments: "Received office supplies from Chicago
- What are some examples of implicit and explicit bias?