Author Topic: What is the difference between cross joins and natural joins?  (Read 226 times)

Offline Regan

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
What is the difference between cross joins and natural joins?
« on: October 24, 2014, 10:04:21 AM »
Hi, I'd like to ask you a little problem, I hope you can help me, what is the difference between cross joins and natural joins? Thank you to inform me as soon as possible by return message.
« Last Edit: April 22, 2017, 02:38:36 PM by Sofyene »



Offline Luka

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
Re: Cross joins and natural joins
« Reply #1 on: April 22, 2017, 02:39:46 PM »
CROSS JOIN creates all possible pairings of rows from two tables, whether they match or not. You don't use any join condition for a cross product, because the condition would always be true for any pairing.


NATURAL JOIN is just like an INNER JOIN, but it assumes the condition is equality and applies for all columns names that appear in both tables.


 

Sitemap 1 2 3 4 5 6 7 8 9