Steve,
Tuesday, July 23, 2002, 7:36:39 AM, you wrote:
S> Can anyone tell me how do achieve the following in MySQL:
S> Update oitems
S> SET Pstatus = SELECT product.Pstatus from products
S> WHERE oitems.Pstatus not like "%Printed%"
S>AND oitems.ProdCode=products.Code
S> i.e.
Can anyone tell me how do achieve the following in MySQL:
Update oitems
SET Pstatus = SELECT product.Pstatus from products
WHERE oitems.Pstatus not like "%Printed%"
AND oitems.ProdCode=products.Code
i.e. I need to update all order item status flields that have not been
printe
