Which keywords are mandatory in a query that fetches data from several tables linking them between themselves (not including cartesian product case)?
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

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback