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

Database
Enthusiast

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

Is Table A LEFT OUTER JOIN TABLE B 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)

Tags (1)
2 REPLIES
Junior Contributor

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

Yes, it's only a syntax variation.

Enthusiast

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

Thanks