تفاوتINNER JOIN و LEFT JOIN

[tayebeh]

با سلام
لطفا واسم توضیح بدید. راستی RIGHT JOIN هم داریم؟
با تشکر
بای :oops: :oops: :mrgreen: :mrgreen:

[vadood]

از BOL


Left outer join All rows from the first-named table (the "left" table, which appears leftmost in the JOIN clause) are included. Unmatched rows in the right table do not appear

Right outer join All rows in the second-named table (the "right" table, which appears rightmost in the JOIN clause) are included. Unmatched rows in the left table are not included

Inner join A join that displays only the rows that have a match in both joined tables. (This is the default type of join in the Query Designer.)

[tayebeh]

با سلام
ممنونم ابهامم برطرف شد :thnx: :thnx: :thnx: :thnx: