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