joins

Question

what is different types of joins and what is difference between them ?

please explain with example.

Answer 1

Conditional Join:

• condition can be any conditional operator
• Comparison can be between two columns ot column and constant

Equi Join

• Only equality condition can be used
• Comparision between two columns only

Natural Join

• Equi join where same name column are matched for equlaity

Source: https://www.w3schools.com/sql/sql_join.asp