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,150 points • 5,811 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,150 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 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 • 172 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 • 206 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,710 points • 215 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,290 points • 226 views
0 votes
1 answer

Difference between primary key a composite key

Primary key is that column of the table ...READ MORE

answered Sep 5, 2018 in Database by CodingByHeart77
 • 3,710 points • 3,444 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,710 points • 824 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
 • 82 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,150 points • 190 views
+1 vote
2 answers

Difference between SQL and PL/SQL

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

answered Sep 25, 2019 in Database by gautham
 • 288 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.