hi,
thank you very much,

yes it works.

have a nice time

regards.

m.qasem
>hmm, help says you can use FROM table as table_alias like in SELECT-SQL, but it does not seem to work. So back to your version:
>

>DELETE FROM (ma) WHERE EXISTS(SELECT * FROM NEWADSL WHERE &ma..telno==newadsl.telno)
>

>or
>

>DELETE FROM (ma) WHERE &ma..telno in (SELECT telno FROM NEWADSL)
>

>
>Bye, Olaf.