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)
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)
Yes those are equivalent. Left join is generally preferred because it is the most commonly used, so the meaning is more immediately clear.