Why will the following statement result in an error?

SELECT l.city, d.department_name FROM locations l JOIN departments d USING (location_id) WHERE d.location_id = 1400;

A) Syntax of the USING clause is incorrect.
B) WHERE clause cannot be used in a query with USING.
C) The field in the USING clause cannot have a qualifier.
D) There is nothing wrong

C (The field in the USING clause cannot have a qualifier.)

Computer Science & Information Technology

You might also like to view...

When you export a table to Excel, the field names become the column headings and the records become the rows in the Excel spreadsheet

Indicate whether the statement is true or false

View
Computer Science & Information Technology

Which of the following are correct declarations of iterators for STL containers? You may assume that the proper header has been included and that a using directive makes the names from namespace std available.

a) ``` vector::iterator vecIterator; ``` b) ``` list::iterator listIterator; ``` c) ``` deque::iterator dequeIterator; ``` d) ``` list::iterator listIterator; ```

View
Computer Science & Information Technology