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
 Other SQL Server Topics (2005)
 Sql query

Author  Topic 

taunt
Posting Yak Master

128 Posts

Posted - 2010-06-29 : 14:15:02
OK I was wondering how I could do a query on a database lets call it products in the upc field it would tell me any results that weren't in the database. Say upc's 01, 02, 03 are in the database. I did a search for 01, 02, 03, 04. It would display 04 wasn't in the system. Hope this makes sense. Thanks for any help.

vijayisonly
Master Smack Fu Yak Hacker

1836 Posts

Posted - 2010-06-29 : 14:46:39
Do you have a list of those valid upc's somewhere? Maybe in another table or something?
Go to Top of Page
   

- Advertisement -