网友您好, 请在下方输入框内输入要搜索的题目:
ViewtheExhibitandexaminethestructureoftheORDERSandORDERJTEMStables.EvaluatethefollowingSQLstatement:SELECToi.order_id,product_jd,order_dateFROMorder_itemsoiJOINordersoUSING(order_id);WhichstatementistrueregardingtheexecutionofthisSQLstatement?()
A.ThestatementwouldnotexecutebecausetablealiasesarenotallowedintheJOINclause.
B.ThestatementwouldnotexecutebecausethetablealiasprefixisnotusedintheUSINGclause.
C.ThestatementwouldnotexecutebecauseallthecolumnsintheSELECTclausearenotprefixedwithtablealiases.
D.ThestatementwouldnotexecutebecausethecolumnpartoftheUSINGclausecannothaveaqualifierintheSELECTlist.
参考答案