سؤال في Join

[mmsalman87]

هل يتم فعليا استخدام JOIN Tables 1999 مثل :
cross join
natural join
using clause
and on
inner outer left
الى اخره من هذه الانواع ام ان المستخدم حاليا هو النوع الاخر وهي:
outer join , self join , equijoin الى اخره

وشكرا

[hanyfreedom]

Joining tables with the NATURAL JOIN, USING, or ON clauses results in an inner join. Any unmatched rows are not displayed in the output. To return the unmatched rows, you can use an outer join. An outer join returns all rows that satisfy the join condition and also returns some or all of those rows from one table for which no rows from the other table satisfy the join condition