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: 285
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