Help with my first Delete Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dave - 05 Jan 2006 12:38 GMT

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

Reply to this Message

TedMi - 05 Jan 2006 13:45 GMT

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

Signature

Ted

Reply to this Message

John Spencer - 05 Jan 2006 14:00 GMT

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"));

> This is the SQL from the Design View.
>
[quoted text clipped - 10 lines]
>
> dave

Reply to this Message

Dave - 05 Jan 2006 15:03 GMT

Thank you John!!

Worked like a champ :-)

Dave

> Try
>
[quoted text clipped - 18 lines]
>>
>> dave

Reply to this Message