Sql update column wont regonize diffeent table-CodePudding

The code looks like this but it shows me multipart identifier loty and users could not be found

UPDATE zabukowane
SET cenabiletu = zabukowane.cenabagazu   loty.cena
WHERE zabukowane.idlotu = loty.idlotu AND zabukowane.userid = users.userid
FROM zabukowane JOIN loty, users;

I want to set column(cenabiletu) in zabukowane to take from table called loty column cena where usersid in users is equal to userid in zabukowane and idlotu in loty is equal to idlotu in zabukowane and adding to cenabagazu and summing that up in cenabiletu column so it may look like this cenabiletu.zabukowane=cena.loty cenabagazu.zabukowane

CodePudding user response：

Seems that you are missing a few points. Try it in this way:

UPDATE zabukowane
SET cenabiletu = zabukowane.cenabagazu   loty.cena
FROM zabukowane 
INNER JOIN loty on  zabukowane.idlotu = loty.idlotu
Jo
INNER JOIN users on zabukowane.userid = users.userid

This post question gmhas a great explanation: How do I UPDATE from a SELECT in SQL Server?.