natural join

• natural join has two behaviours of there is any relationship between table it
• if there is no relation bt table catretion or cross join

when we go for natural join

• if we doesn’t know the structure of a table or doesn’t identify relation between table

select * /[distinct] column name_name/ expression [alias]
fromt table_name 1 natural join tbable_name 1;

• natural join doesn’t have oracle

• natural join

• outer join

• left right

• full

• self join

• self join multiple tables