hi,

it works,thank you

but also i need to delete from table 2 all customer_no =table1.customer_no

SELECT * FROM table2 WHERE customer_no ((IN) i mean =) (SELECT customer_no FROM table1)
use table 2
delete

thanks