select a.column2,b.column2 from tableA a left join tableB b on a.column1=b.column1
Suppose we have a left join query like below, I am simply interchanging the tablename from tableA to tableB and tableB to tableA like below
select a.column2,b.column2 from tableB a left join tableA b on a.column1=b.column1
So this one going to produce the same result if I uses the right join here, So why SQL have this right join ?
New contributor
Raj kumarnewemail is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.