Thank you so much, I guess my sql skills need sharpening. I have been trying all night to find out how to do a join with delete. I thought I needed to mention t2 in the from clause, but that didn't work. This worked great.
Sally ----- Original Message ----- From: "Martijn van Oosterhout" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, November 30, 2004 10:38 AM Subject: Re: [GENERAL] delete with index scan ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
