1

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)

1

1 Answer 1

1

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.