試題詳解

93. select c_name, clsname from studata inner join score using (s_id) where score.math > 90; 下列那個 SQL 指令可和上述 SQL 指令得到相同的查詢結果？
(A)select c_name, clsname from studata inner join score having studata.s_id =score.s_id and score.math>90;
(B)select c_name, clsname from studata where studata.s_id=score.s_id and score.math>90;
(C)select c_name, clsname from studata, score where score.math>90;
(D)select c_name, clsname from studata, score where studata.s_id=score.s_id and score.math>90;