>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).