Illustrates the JOIN commands

Question

Illustrates the JOIN commands?

Answer 1

JOIN:

• It is the form of SELECT command which combines info by two or more tables.

• Kinds of Joins are Simple (that are Equijoin and Non-Equijoin), Outer and Self join.
• Equijoin returns rows by two or more tables combined together based on an equality condition within the WHERE clause.

• Non-Equijoin returns rows by two or more tables based on a relations other than the equality condition within the WHERE clause.

• Outer Join combines two or additional tables returning which rows from one table which have no direct match within the other table.

• Self Join joins a table to itself like though that were two separate tables.