Help with my first Delete Query

[Dave]

This is the SQL from the Design View.

I get an "Could not delete from specified tables" prompt.

This is my first attempt at a Delete Query.


DELETE EmplDB.*, EmplDB.STATUS
FROM EmplDB INNER JOIN EmplIDDB_Del ON (EmplDB.STATUS = EmplIDDB_Del.STATUS)
AND (EmplDB.EMPLID = EmplIDDB_Del.EMPLID)
WHERE (((EmplDB.STATUS)="i"));

Thanks in advance

dave

 

[Guest]

The syntax of the DELETE statement allows a filed list of [tableName].* - you
cannot name aditional fields.

 

[John Spencer]

Try

DELETE DISTINCTROW EmplDB.*
FROM EmplDB INNER JOIN EmplIDDB_Del ON (EmplDB.STATUS = EmplIDDB_Del.STATUS)
AND (EmplDB.EMPLID = EmplIDDB_Del.EMPLID)
WHERE (((EmplDB.STATUS)="i"));

 

[Dave]

Thank you John!!

Worked like a champ

Dave

Try

DELETE DISTINCTROW EmplDB.*
FROM EmplDB INNER JOIN EmplIDDB_Del ON (EmplDB.STATUS =
EmplIDDB_Del.STATUS)
AND (EmplDB.EMPLID = EmplIDDB_Del.EMPLID)
WHERE (((EmplDB.STATUS)="i"));