Missing information Search

[Robert Gehrig]

Hi

I have two tables that are structured like so:

Table 1:
ID		int
K_Code	int

Table 2
K_Code	int
K_Desc		char

Table 2 has been corrupted and may be missing some records.

What I need to be able to do is find any values of K_Code in table 1 that don't appear in
table 2.

Thanks

Robert Gehrig
Webmaster at www.gdbarri.com

e-mail: robert.gehrig@stripped