B left join A is same as A right join B.now my question is why should i use right join ?in sql serv

Posted by Chamu under Sql Server on 12/27/2017 | Points: 10 | Views : 1435 | Status : [Member] | Replies : 1

B left join A is same as A right join B.now my question is why should i use right join ?in sql server

Reply | Reply with Attachment

Posted by: Kirthiga on: 5/17/2018 [Member] Starter | Points: 25

0	Create Table A(Sno int) Create Table B(Sno int) insert into A values(1),(2),(3),(4) insert into B values(4),(5),(6) select * from A left join B on a.Sno=b.Sno select * from A right join B on a.Sno=b.Sno Chamu, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts