I am working on some database tables to handle messages on an intranet. One table looks like this
msg_id | subject | message | date there is another table used to track senders and recipients that looks like this msg_id | sender_id | recipient_id | Now what I would like to do is delete any messages that are older than 45 days and the corresponding records in the second table. How can I delete matching records from both tables at the same time? thanks, Luis R. Lebron Project Manager Sigmatech, Inc
