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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-19 : 11:22:09
|
Byron writes "I have 2 tables .... for a load matching website.
Cities & Loads
When loads are added to the LOADS table, I need to make sure that the destination cities
exists in the CITIES table....
After they are added (5000 at a time), I want to perform a query similar to this that will find cities that are not in the CITIES table.
select state,city from loads inner join cities on cities.state & cities.city <> loads.state & loads.city;
This does not work....please help...." |
|
|
|
|
|
Check for missing cities