首页->2023中级大数据分析师

要把按日统计的PV和IP数据合并到一张表中，下列代码正确的是（）。

（A）SELECT ip.time_local_date,ip.quantity ipquantity,pv.quantity pvquantity From log_ip ip JOIN log_pv pv ON ip.time_local_date=pv.time_local_date;

（B）SELECT ip.time_local_date,ip.quantity ipquantity,pv.quantity pvquantity From log_ip ip,log_pv pv ON ip.time_local_date=pv.time_local_date;

（C）SELECT ip.time_local_date,ip.quantity ipquantity,pv.quantity pvquantity From log_ip ip JOIN log_pv pv where ip.time_local_date=pv.time_local_date;

（D）SELECT ip.time_local_date,ip.quantity ipquantity,pv.quantity pvquantity From log_ip ip JOIN log_pv pv