CODEWITHSUNDEEP
sqlleft-joinouter-joinright-join
user2845337
user2845337

Reputation: 43

Table A Left Outer JOIN Table B VS Table B Right Outer JOIN A

Is TABLE A LEFT OUTER JOIN TABLE B the same as TABLE B RIGHT OUTER JOIN TABLE A in in terms of output and performance?

(Regardless of data content and size of table A, and table B)

Upvotes: 1

Views: 823

Answers (1)

HLGEM
HLGEM

Reputation: 96640

Yes those are equivalent. Left join is generally preferred because it is the most commonly used, so the meaning is more immediately clear.

Upvotes: 1

Related Questions