Ask
Login
0
25kviews
What is JOIN? Explain different types of join with example
written 5.8 years ago by gravatar for meghalikalyankar meghalikalyankar • 2.2k modified 2.5 years ago by gravatar for binitamayekar binitamayekar ★ 6.4k
database management systems advanced database management systems
ADD COMMENT EDIT
1 Answer
2
625views
written 5.8 years ago by gravatar for meghalikalyankar meghalikalyankar • 2.2k

This type of join is useful when we know the joining conditions.

Syntax:

SELECT Column_list

FROM Table1, Table 2

WHERE Join_Condition

Types of Join:

1.Natural Join

• A natural join returns all rows by matching values in comman columns having same name and data types of columns and that column …

Create a free account to keep reading this post.

and 3 others joined a min ago.

ADD COMMENT EDIT
Please log in to add an answer.