Difference between cross join and natural join

Question

Hi!!

Can someone tell me the difference between cross join and natural join?

Answer 1

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.

Comments

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

---

Kya ye answer hindi me nhi h

Answer 2

Cartesian product produce cross product of two tables and the resulting table will contain all the attributes of both table including duplicate columns also.

Natural join joins two table based on same attribute name and datatype and resulting table will contain all attributes of both tables but keep only one copy of each common table.