ekendricks

Using SQL 2000 and ASP

I have one table "Obituary", and a second table "GBComments". The "Obituary" table has a field "Sponsored" which is an expiration date for entries to GBComments to be seen by the public. Entries to the GBComments has the "ID" of the Obituary table to identify GBComments records with those of the Obituary record.

What I need to accomplish is to delete all records in the GBComments table WHERE the "Sponsored" Date (which is in the Obituary Table)is =< Today.

If someone could shed some light on this, I would greatly appreciate it.

Thanks

Ernest

Webforumz Staff

I don't remember the exact sytnax of it, but I'd say try something like:

DELETE FROM GBComments WHERE ID IN (SELECT ID FROM Obituary WHERE Sponsored =<Date)

That should be close, I don't have time to look it up at the moment but will if it doesn't work for you.