Which two statements are true regarding the USING and ON clauses in table joins?()
- A、Both USING and ON clauses can be used for equijoins and nonequijoins
- B、Amaximum of one pair of columns can be joined between two tables using the ON clause
- C、The ON clause can be used to join tables on columns that have different names but compatible data types
- D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
正确答案:C,D
答案解析:有

微信扫一扫手机做题