Select * records from tab A in a Multijoin(A,B,C)

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Select * records from tab A in a Multijoin(A,B,C)

Author

Topic

deepugun
Starting Member

11 Posts

Posted - 2013-06-04 : 10:11:55

Hello All,
Please let me know how i should get all the records from Table A as they are some null values for role_Id in table A
select a.ad,c.ad as re
from A
join B
on A.Role_ID = B.Role_ID
JOIN C
on C.Address_Id = B.ID

I am planning to use the below query to get all the records from Table A but wanted to know if has any catches

select a.ad,c.ad as re
from A
left outer join B
on A.Role_ID = B.Role_ID
left outer JOIN C
on C.Address_Id = B.ID

MuMu88
Aged Yak Warrior

549 Posts

Posted - 2013-06-04 : 12:00:18

You can answer that question better than any of us.
Try your query on a small data set and see if you are getting what you want and then tweak the query until you are satisfied.
If you need assistance with the query, post your table description, input data and expected output.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources