Download
100% FREE
Office Document APIs for .NET
Online: 559
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Forums
>
Sql Server
>
Loading ...
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 : 731 | Status :
[Member]
| Replies : 1
Write New Post
|
Search Forums
|
Resolved Posts
|
Un Answered Posts
|
Forums Home
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
Alert Moderator
Responses
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
Login to post response
Latest Posts
Get all materials of parent and its children in an array except for few
(0)
New
Container in Media Query
(0)
How to send keys to specified app with title?
(1)
NullReferenceException when adding list
(0)
How to run a VB.NET exe in the backend on Azure VM server?
(0)
Null Reference Exception
(0)
How do you parse the Subject Alternate Names from an X509Certificate2?
(0)
Framework64\v4.0.30319\Config\web.config file is not well formed
(0)
More ...