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 : 303 | 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




Responses

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

Up
0
Down
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

Login to post response