Delete Query

[blander]

Hi guys,

The following query


DELETE DD5592.*
FROM DD5592, [module]
WHERE DD5592.Sortcode=module.BASortCode;


Results in a message: Cannot delete from the specified tables.

Any ideas??

 

[gemma-the-husky]

it probably doesnt like the ,[module] bit