Subquery in delete statement

[anithamg]

delete tbltravel as tt1 where tt1.travelerid, tt1.recordlocator in
(SELECT tblTravel.TravelerID, tblTravel.RecordLocator,max(TravelDate)
FROM tblTravel
group by travelerid,recordlocator
having max(traveldate) < date()-30)

This doesn't work def.. I need a solution where u can condition on 2 fields for delete statement with the result from a subquery.

 

[ssecca]

Delete Tbl1.*
From tbl1 t
Where t.Field1 in (Select field From Tbl2....) and
t.field2 in (select field From tbl3....)

If I have understood correctly the above will give you a patern to work from. It is important that the IN (SELECT..)returns only one field to compare to.

ssecca