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.
Author |
Topic |
ssimon
Starting Member
16 Posts |
Posted - 2013-04-17 : 09:30:29
|
I am transferring a Access db that a past employee built over to MS SQL 2008. I came across a couple of tables that I am trying to run a query against, but can not seem to get it to work.TableAItem Issue IssueDesc2zw 5 FOOTableBItem Issue IssueDesc2zw 20 BARTableCItem Issue Fail2zw 5 02zw 20 0Select c.Item,a.IssueDesc as ThisIssue, b.IssueDesc as ThatIssueFROM TableC as cInner Join TableA as aOn c.Issue = a.IssueInner Join TableB as bOn c.Issue = b.Issue WHERE c.Item='2zw'What I would like to return is:Item ThisIssue ThatIssue2zw FOO NULL2zw NULL BAR |
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-04-17 : 09:36:38
|
--just change INNER JOIN to LEFT JOIN Select c.Item,a.IssueDesc as ThisIssue, b.IssueDesc as ThatIssueFROM TableC as cLEFT Join TableA as aOn c.Issue = a.IssueLEFT Join TableB as bOn c.Issue = b.Issue WHERE c.Item='2zw'--Chandu |
|
|
ssimon
Starting Member
16 Posts |
Posted - 2013-04-17 : 09:39:35
|
Thank you... |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-04-17 : 09:40:07
|
quote: Originally posted by ssimon Thank you...
Welcome--Chandu |
|
|
mmkrishna1919
Yak Posting Veteran
95 Posts |
Posted - 2013-04-17 : 09:57:30
|
Try this..Select c.Item,a.IssueDesc as ThisIssue, b.IssueDesc as ThatIssueFROM #C as cLEFT Join #A as aOn c.Issue = a.IssueLEFT Join #B as bOn c.Issue = b.Issue WHERE c.Item='2zw'M.MURALI kRISHNA |
|
|
|
|
|