Can anyone tell me how, using SQL 2000 (either stored proc or job or script or whatever), I can compare a field from one table to a field in another table... and, if there are values in one, I need the same values in the other??? It only has to work one way. Table1 field1 called id has 500 values. Table2 field1 has 445 values. How can I run something that looks at Table1 Field1, compares it to Table2 Field1 and copies those that are missing to Table 2 Field1????