Educational

INNER JOIN vs LEFT JOIN

Written by

Saim Khalid

in

  • INNER JOIN → returns only matching rows.
  • LEFT JOIN → all rows from left + matched rows from right.
  • RIGHT JOIN → all rows from right + matched rows from left.
  • FULL JOIN → all rows from both sides.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

More posts