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 • 8,956 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 9, 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,100 points • 297 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,100 points • 475 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 • 5,837 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 • 524 views
0 votes
2 answers

Difference between primary key a composite key

candidate  key: It is the collection of ...READ MORE

answered Oct 14, 2020 in Database by anonymous
 • 13,724 views
0 votes
1 answer

Difference between STUFF & REPLACE function

STUFF Function: This function is used to ...READ MORE

answered Oct 10, 2018 in Database by CodingByHeart77
 • 3,720 points • 987 views
0 votes
0 answers

Different between mongoDB and Postgresql

Any one can you explain different between ...READ MORE

Feb 8, 2019 in Database by Ajay
 • 126 views
0 votes
1 answer

Error:Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Arabic_CI_AS" in the equal to operation.

Hello @kartik, You can resolve the issue by ...READ MORE

answered May 13, 2020 in Database by Niroj
 • 82,680 points • 2,186 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 • 406 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
 • 499 views
"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.