Difference between cross join and natural join

+1 vote
Hi!!

Can someone tell me the difference between cross join and natural join?
Oct 12, 2018 in Database by DataKing99
 • 8,240 points • 11,161 views

1 answer to this question.

+1 vote

The cross join produces the cross product or Cartesian product of two tables whereas the natural join is based on all the columns having the same name and data types in both the tables.

answered Oct 12, 2018 by DataKing99
 • 8,240 points
SORRY BRO.YOU ARE PARTIALLY CORRECT.

IN NATURAL JOIN ITS GIVES MATCHING ROW WHEN THOSE TABLE CONSIST P.K AND F.K RELATIONSHIP.

AND NATURAL JOIN GIVES CROSS PRODEUCT RESULT WHEN WE DO N.JOIN BETWEEN THOSE TABLE WHICH HAS NO P.K AND F.K RELATIONSHIP
commented Sep 10, 2019 by AMIT ROY
Kya ye answer hindi me nhi h
commented Jan 11, 2020 by anonymous

Related Questions In Database

0 votes
1 answer

Can you please explain the difference between inner join and outer join in database?

Hi Suraj, You have a doubt regarding inner join ...READ MORE

answered May 28, 2019 in Database by sampriti
 • 1,120 points • 453 views
0 votes
1 answer

Can you explain what is the difference between UNION and Join?

Hi Sahana,  I got your doubt, Checkout these ...READ MORE

answered May 30, 2019 in Database by sampriti
 • 1,120 points • 655 views
0 votes
0 answers

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?

What's the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL ...READ MORE

Aug 13 in Database by Kithuzzz
 • 4,880 points • 7 views
0 votes
1 answer

Difference between single and double quotes in SQL

Single quotes are used to indicate the ...READ MORE

answered Sep 11, 2018 in Database by CodingByHeart77
 • 3,720 points • 15,665 views
0 votes
1 answer

Difference between clustered and non clustered index in SQL

The differences between the clustered and non ...READ MORE

answered Sep 28, 2018 in Database by Sahiti
 • 6,380 points • 907 views
0 votes
1 answer

Difference between datetime and timestamp in sqlserver?

Timestamp is a synonym for rowversion, according ...READ MORE

answered Feb 16 in Database by Vaani
 • 7,020 points • 799 views
0 votes
1 answer

What is the difference between SQL, PL-SQL and T-SQL?

SQL SQL is the standard language for relational ...READ MORE

answered Feb 16 in Database by Vaani
 • 7,020 points • 118 views
0 votes
0 answers

CROSS JOIN vs INNER JOIN in SQL

What is the difference between CROSS JOIN and INNER JOIN? CROSS ...READ MORE

2 days ago in Database by Kithuzzz
 • 4,880 points • 2 views
0 votes
1 answer

Difference between Inner Join & Outer Join

The difference is as follows: INNER JOIN: Returns all those ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
 • 8,240 points • 668 views
+1 vote
3 answers

Difference between SQL and PL/SQL

In Oracle database administration, there are two ...READ MORE

answered Sep 25, 2019 in Database by gautham
 • 730 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.