> -----Original Message----- > From: Jay Pipes [mailto:[EMAIL PROTECTED] > Sent: Thursday, December 20, 2007 11:25 AM > To: Jerry Schwartz > Cc: mysql@lists.mysql.com > Subject: Re: Forbidden subquery > > No problem. I hope by now you figured out I made a typo... :) The > WHERE in the DELETE should be prod_price_chg_flag='O', not ="X" :) > [JS] Actually, I didn't look at your solution that closely because in the meantime my problem got a lot more complicated. I'm going to have to match on more than one field, so I won't be able to delete all of the "O" records. I'm going to have to match on a varchar field as well, and do manual cleanup of any typos.
Your temp-table solution is still going to be at the heart of my work. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
