>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..
It will delete all matching records (e.g. all records from Incros that would satisfy the INNER JOIN condition).
If it's not broken, fix it until it is.
My Blog