To avoid errors, the inner join or left join is utilised for self join. 2. Cross Join: With a cross join, we may join every row of both tables. It works in the same way as the cartesian product, which combines all the rows.
The CARTESIAN JOIN or CROSS JOIN returns the Cartesian product of two or more connected tables' sets of records. As a result, it translates to an inner join in which the join-condition evaluates to either True or False or when the join-condition is not included in the statement.
The cartesian product in SQL Server is actually a cross-join that returns all the data from all the tables given in the query: each row from the first table is coupled with all the rows from the second table. When there is no relationship defined between the two tables, this occurs.
ANSI-standard INNER, LEFT OUTER, RIGHT OUTER, FULL OUTER, and CROSS are the five forms of JOIN defined by SQL.
Inner Join / Simple Join.
Left Outer Join / Left Join.
Right Outer Join / Right Join.
Full Outer Join.
Cross Join.
Self Join.
Learner's Ratings
3.8
Overall Rating
45%
21%
13%
11%
10%
Reviews
A
Arvind Kumar
5
very nice course for begginer to under stand
H
hemant
5
Hello sir, explaination is excellent. I have a request please send the db in excel or SQL file
J
Juboraj Juboraj
4
Explain details & easy to understand.
A
Aman Kanaujia
4
All good , but provide the data also for the assignment , Without data the interest is less day by day from the course. So, try to solve this problem as asap.
S
Snehil
4
Everything is good but keyboard sounds more harsh and overlap your voice whereas this course is best.
F
FAROOK MOHAMMAD
5
Hello sir, explaination is excellent. I have a request please send the db in excel or SQL file.
H
Hari Prakash
4
In SQL Join Function's 2nd video - Teacher's voice dose not match with background content that are plays
A
Aakash Mavar
5
Hello sir
Mera Abhi graduation hu he Mene Mechanical Engineering BTech ki Hai me Data analysis me Apna career Bana skat ho Kya
Share a personalized message with your friends.