Problem on sql statement, Problem on SQL statement

Problem on sql statement

Assignment Help Computer Engineering

Reference no: EM133212

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.

Reference no: EM133212

Questions Cloud

Write down program that models an employee : Write down program that models an employee

Generate queries for new database : Generate Queries for New Database

Separate following program into appropriate lexemes : Separate following program into appropriate lexemes

Write a java program that uses a two-dimensional array : Write a Java program that uses a two-dimensional array

Problem on sql statement : Problem on SQL statement

Identify and classify the it infrastructure components : Identify core and side business activities of UPS and explain how same are driven by technology, Identify and classify the IT infrastructure components available at UPS and its subsidiaries

Write down an automated checkout program : Write down an automated checkout program

What are the kinds of information systems : What are the kinds of information systems

What are the types of malicious attack : What are the types of malicious attack

User Account

All Pages