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 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.
Additional Requirements
Other Requirements: CUSTOMER (CustomerSK, Name, Phone, EmailAddress)
STOVE (SerialNumber, Type, Version, DateofManufacture)
REGISTRATION (CustomerSK, SerialNumber, Date)
STOVE_REPAIR (RepairInvoiceNumber, SerialNumber, Date, Description, Cost, CustomerSK)
3. List all versions of stoves of type "Maytag" that have no record of being repaired.
SELECT VERSION?
FROM STOVE, STOVE_REPAIR
WHERE DISTINCT STOVE.Type = 'Maytag' WHERE STOVE.SerialNumber = STOVE_REPAIR.SerialNumber;