Cannot have a qualifier in the select list while performing a JOIN w/ USING keyword.

Posted by JuiceBerry123 on Stack Overflow See other posts from Stack Overflow or by JuiceBerry123
Published on 2010-05-23T03:14:57Z Indexed on 2010/05/23 3:20 UTC
Read the original article Hit count: 281

Filed under:
|
|

I am looking at a practice test that doesn't have explanations about the correct answers. The question I'm confused about basically asks why the following SQL statement can never work:

SELECT oi.order_id, product_jd, order_date
FROM order_items oi JOIN orders o
USING(order_id);

The answer it gave was: "The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list"

Can someone elaborate on this? I am pretty stumped.

© Stack Overflow or respective owner

Related posts about sql

Related posts about join