update query problem
Posted: Tue Apr 07, 2009 3:25 am
I want to update product status if number of bids are 1 but my query is giving my error.
any help?
here is query.
thanks.
any help?
here is query.
Code: Select all
update product set product.product_status = 2 where product.PK_ID in (
select product.PK_ID,count(bids.FK_PRODUCT_ID) from bids, product where product.PK_ID = bids.FK_PRODUCT_ID and product.FK_SELLING_TYPE_ID = 1 and product.product_status = 0 group by bids.FK_PRODUCT_ID
having count(bids.FK_PRODUCT_ID) = 1 limit 0,3
)