Delete query help!!!
Posted: Thu Jun 26, 2008 5:22 pm
Hello,
I have 2 tables( product, product_attribute), and product_attribute table has product_id field. I want to delete all attributes have product_id that not exist in product table. I tried NOT EXIST and NOT IN but i keep getting errors. I need help.
Thanks
I have 2 tables( product, product_attribute), and product_attribute table has product_id field. I want to delete all attributes have product_id that not exist in product table. I tried NOT EXIST and NOT IN but i keep getting errors. I need help.
Thanks