I Use SQL 2000, Can You Use One Delete Query To Delete 2 Tables?

this is my Delete Query NO 1

alter table ZT_Master disable trigger All

Delete ZT_Master WHERE TDateTime> = DATEADD(month,DATEDIFF(month,0,getdate())-(select Keepmonths from ZT_KeepMonths where id =1),0) AND TDateTime< DATEADD(month,DATEDIFF(month,0,getdate()),0)


alter table ZT_Master enable trigger All

 

I have troble in Delete Query No 2

here is a select statemnt , I need to delete them

select d.* from ZT_Master m, ZT_Detail d
where (m.Prikey=d.MasterKey)  And
 m.TDateTime> = DATEADD(month,DATEDIFF(month,0,getdate())-(select Keepmonths from ZT_KeepMonths where id =1),0) AND m.TDateTime< DATEADD(month,DATEDIFF(month,0,getdate()),0)

I tried modified it as below

delete d.* from ZT_Master m, ZT_Detail d
where (m.Prikey=d.MasterKey)  And
 m.TDateTime> = DATEADD(month,DATEDIFF(month,0,getdate())-(select Keepmonths from ZT_KeepMonths where id =1),0) AND m.TDateTime< DATEADD(month,DATEDIFF(month,0,getdate()),0)

but this doesn't works..

 

can you please help?

and can I combine these 2 SQL Query into one Sql Query? thank you