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


Subject
Written By
Posted
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.