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 |
lejanco
Starting Member
8 Posts |
Posted - 2014-07-09 : 19:03:22
|
I am trying to write a query that selects all the mis_key that is not in the subquery. The left join query is working but when nested it comes out blank. Here is the query:select *from [TLC NEW Inv. Anal.].dbo.['Home Decor$']WHERE NOT EXISTS(SELECT *FROM [TLC New].DBO.['Fabric or basket accessory$'] LEFT JOIN [TLC NEW Inv. Anal.].DBO.['Home Decor$']ON [TLC New].DBO.['Fabric or basket accessory$'].[Item #]=[TLC NEW Inv. Anal.].DBO.['Home Decor$'].mis_key)Laura Janco |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-09 : 19:19:16
|
http://www.sqlservercentral.com/articles/Best+Practices/61537/Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|