Member Avatar for tyson.crouch

G'day,

I've just been going over MySQL joins and just have a few small questions.

1. Are LEFT and RIGHT joins forms of OUTER only or are the both Inner and Outer?

2. Can you only perform a NATURAL join on Inner join classifications?


Cheerz,
TC

  • 2 Contributors
  • 2 Replies
  • 58 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by tyson.crouch
Member Avatar for urtrivedi

Inner and natural are same
left and rigth are used with outer join.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.