delete from titleauthor where au_id='###'
delete from authors where au_id='###'
先删titleauthor表中数据,再删authors表中数据.
或者你在SQL数据库中编一个触发器
CREATE TRIGGER [aaa] ON titleauthor
FOR DELETE
AS
declare @i as int
set @i=(select au_id from deleted)
delete oswxh where au_id=@i