Specify the Table containing the records you want to delete

[Denmla]

Hello all,

I need help with chose right table for delete row.

My query ;

DELETE Sken.Barkod, qSkenirano.Nalog
FROM qSkenirano INNER JOIN Sken ON qSkenirano.Barkod = Sken.Barkod
WHERE (((qSkenirano.Nalog) Is Null));

After that I get error ;
Specify the Table containing the records you want to delete.

I need delete only one row in table Sken.Barkod.
Table is linked with query qSkenirano and criteria is Null.

Can somebody help me with sql form for query?

Thanks in advice !!!

 

[Ranman256]

You cannot delete records from a joined table. You must use the IN clause.

Use the query wizard and make a FIND DUPLICATES query. Then look at its design, Observe the key field where the criteria is using a sub query.
It matches the key field in the sub query.

Use THIS in your delete query.

 

[Denmla]

I can't get right form, can you help me?

can you write me right form