Robert
>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.
SELECT t1.k_code
FROM table1 t1
LEFT JOIN table2 t2 USING (k_code)
WHERE t2.k_code IS NULL;
PB
-
Robert Gehrig wrote:
Hi
I have two tables that are structured like so:
Table 1:
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.
T