I have two tables, one for the articles and one with orderrows. When I update the price in the article table i want to make a query to update the price in orderrows on all rows with a certain orderstatus.
I can't figure out how to write this query... I tried UPDATE orderrows SET price = article.price where article.artnumber = orderrows.artnumber I also tried different JOIN without success. Can anyone please help me!!! --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
