update whit inner join sice other table

Question

update whit inner join sice other table

jeffersonsanabria24

Newbie

Points: 8
More actions
March 20, 2018 at 3:57 pm

#336738

update doncentes set (nombre_docente, fecha_nacimiento, email_docente, id_materia) select 'dario','15/7/1000','dario@gmail.com', materias.id_materia from materias inner join doncentes on doncentes.id_materia = materias.id_materia where doncentes.id_docente = 2
what is my error

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

jeffersonsanabria24 - Tuesday, March 20, 2018 3:57 PM
update doncentes set (nombre_docente, fecha_nacimiento, email_docente, id_materia) select 'dario','15/7/1000','dario@gmail.com', materias.id_materia from materias inner join doncentes on doncentes.id_materia = materias.id_materia where doncentes.id_docente = 2
what is my error

Your UPDATE statement is totally wrong. In SSMS highlight UPDATE and then press f1, it will take you to the UPDATE statement in the Microsoft Documents for SQL Server.