Convert SELECT query to DELETE query

Hello All,

I would like to have this select query to be a delete query instead! How do I do that?

/P

SELECT KOM.Number
FROM KOM LEFT JOIN PA ON KOM.[Number] = PA.[Number]
WHERE (((PA.Number) Is Null));

Please Login or Register  to view this content.

more than likely, that will be fine. however, watch out for your relataionships and integrities if you have them set. you can find them here:

Hello, Thanks for the replay!

I tested the code, but I get "Specify the table containing the records you want to delete"

I got no relationship between the tables.

/P

upload ur file

Thank you very much both of you! CK's query worked for me!

Thanks again.