以下ODPSSQL哪个效率最高(见Join语句中where条件的位置)()
A.select*from(select.from a where dt=20140301)A left outer join B on B.id=A. id C.没有区别 D.select* from a left outer join B on E.id=A id and Adt=20140301 F.select* from A left outer join B on G.id=A.id where A dt=20140301