Re: can't triggers reference to tables?(another question)

[Chagh]

and another question(so sorry to take your time). for the trigger below how can i select from deleted in MySQL?
should i use :"where RelatedDocCode like old.doccode"?

SQLServer trigger:
"CREATE TRIGGER DeleteDocument ON [dbo].[_Documents]
FOR DELETE
AS
DELETE
FROM _RelatedDocs
WHERE RelatedDocCode IN ( SELECT DocCode
FROM DELETED ) "

Thanks in advance
Chagh