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
- A population is normally distributed with a mean of -30 and a standard deviation of 5 . ( 1 point ) (a).What is the mean of the sampling distribution for this
- What is Dividend Irrelevance Theory? What are the assumptions of this theory? What is Bird-in-the-Hand Theory? Any implications to managers? What factors can
- A metal rod on a horizontal metal frame from a conducting loop, as illustrated. IF the rod is moved along the frame with a constant velocity v, (a) by which