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 |
|
aspcindys
Starting Member
2 Posts |
 Posted - 2005-09-18 : 03:54:20
|
| I have two tables named datadistint and linksand i need to insert only some values in five fields of links from datadistint but before inputting values we need to ensure they are already not there in links.Insert Into links (LinkTitle,LinkURL,LinkDescription,maincat,cat) Select 1,3,2,4,5 From datadistint Where 1 Not in (Select LinkTitle From links) and 3 Not in (Select LinkURL From links) and 2 Not in (Select LinkDescription From links)and 4 Not in (Select maincat From links)and 5 Not in (Select cat From links)i ran the querry as above but it doesn't work what should i do or what's wrong with this querry,because i need to compare all five fields and then insert only new values. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2005-09-18 : 14:04:43
|
| http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
2 tbles compare and then insert only distinct