MySQL Forums
Forum List  »  Newbie

Re: Update only certain records
Posted by: Peter Brawley
Date: June 22, 2021 10:25AM

That subquery is errant, should throw an error: the klasse table cannot fetch values from the pryse table.

You mean to apply the where condition to both klasse and to pryse? In that case, you need to join them---what column(s) should the Join use?

Options: ReplyQuote

Written By
Re: Update only certain records
June 22, 2021 10:25AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.