Which keywords are mandatory in a query that fetches data from several tables linking them between themselves (not including cartesian product case)?
Explanation
SELECT * FROM table_1 [cross|natural|inner|left outer|right outer|full outer] join table_2 [ON ...]
ON and USING keywords are not necessary for cross and natural join.
CROSS JOIN (cartesian product) can be achieved by simply doing
select * from t1,t2

Следи за CodeGalaxy

Мобильное приложение Beta

Get it on Google Play
Обратная Связь
Cosmo
Зарегистрируйся сейчас
или Подпишись на будущие тесты