Yes the select works.. So if i say the following, it will delete the unmatch records only from 'incros' table right ?

DELETE incros from incros
INNER JOIN
inmast
ON UPPER(incros.fpartno) + UPPER(incros.fcpartrev) = UPPER(inmast.fpartno) + UPPER(inmast.frev)
AND UPPER(incros.fnumber) = UPPER(inmast.custno1)
AND UPPER(incros.fcrosspart) = UPPER(inmast.cpartno1)
WHERE (incros.fctype = 'C')


Thanks Naomi..