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,130 points
1,754 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,130 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

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 in Database by sampriti
• 1,100 points
67 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 in Database by sampriti
• 1,100 points
61 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,680 points
74 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 darklord
• 6,140 points
81 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,680 points
1,440 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,680 points
50 views
0 votes
0 answers

Different between mongoDB and Postgresql

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

Feb 8 in Database by Ajay
41 views
0 votes
1 answer

What is MSLAB and LZO?

MSLAB stands for Memstore-Local Allocation Buffer. Lempel-Ziv-Oberhumer (LZO) ...READ MORE

answered Jul 10, 2018 in Database by Data_Nerd
• 2,360 points
91 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,130 points
82 views
0 votes
1 answer

Difference between SQL and PL/SQL

SQL is a query language that allows ...READ MORE

answered Oct 15, 2018 in Database by DataKing99
• 8,130 points
156 views