以下hive sql语法正确的是()。A.select * from a inner join b on a....
A.select * from a inner join b on a.id<>b.id
B.select * from a where a.id in (select id from b)
C.select sum(a.amt) as total from a where a.total>20
D.select * from a inner join b on a.id=b.id