Many to Many table query - SQL Server Forums

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

SQL Server 2005 Forums

Transact-SQL (2005)

Many to Many table query

Author

Topic

bcanonica
Starting Member

35 Posts

Posted - 2009-03-20 : 14:48:50

I have a table called tblLanguageLocation which has two columns foreign keys LanguageID and LocationID from two tables tblLanguage and tblLocation.

What I need to do is find the Locations that don't have a specific languageID of 1 and then add it. Any ideas or help?

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2009-03-20 : 14:59:24

Try the SELECT first - if it looks good then include the INSERT as well:


insert tblLanguageLocation 
       (LanguageID
       ,locationid )

select 1 as LanguageID
       ,l.locationid 
from   tblLocation l
left join tblLanguageLocation ll
       on ll.locationid = l.locationid
       and ll.languageid = 1
where  ll.locationid is null

Be One with the Optimizer
TG