How to update table using foreign key in sql

Question

I am trying to update a table, but my query is not correct. I don't know where I am making a mistake. Here it is:

UPDATE employee 
SET image = '123.jpg' 
WHERE employee.emp_id=personal_data.emp_Id;

Where emp_Id is a primary key in personal_data table and a foreign key in employee table .

Tag your DBMS. If it's MS-SQL you can join the tables like a normal `SELECT` and then change the `SELECT` to an `UPDATE` and specify the table's alias. `UPDATE a set ...` — Sean, May 18 '16 at 09:17
this thread should help you ... [Update with Join](http://stackoverflow.com/questions/1293330/how-can-i-do-an-update-statement-with-join-in-sql) — RafaelK, May 18 '16 at 09:20
Tag the dbms used!!! You've already got a couple of product specific answers and tips... — jarlh, May 18 '16 at 09:34

score 1 · Answer 1 · edited May 18 '16 at 09:23

1

Try like this:

UPDATE E 
SET E.image = '123.jpg' 
FROM personal_data P 
INNER JOIN employee  E
    ON E.emp_id = P.emp_id

edited May 18 '16 at 09:23

Giorgi Nakeuri

answered May 18 '16 at 09:18

mohan111

Note that this is a product specific answer. (MS SQL Server?) – jarlh May 18 '16 at 09:59

score 0 · Accepted Answer · answered May 18 '16 at 09:32

0

You can use this query.

UPDATE employee  
SET E.image = '123.jpg' 
FROM employee,personal_data
where employee.emp_id = personal_data.emp_id

answered May 18 '16 at 09:32

Sandeep Kumar

Note that this is a product specific answer. (MS SQL Server?) – jarlh May 18 '16 at 09:59
He has SQL tagged (as language), which means ANSI SQL. – jarlh May 18 '16 at 10:08
yes that what i was trying to do but i was missing FROM section @SandeepKumar – Junaid Amjad May 19 '16 at 07:32

2 Answers2