Help in update query

[ScarletPimpernal]

Hi friends,


table-1
-------
id--name--value
-------------
1--'Test'--'Test'
2--'Testing'--'Testing'


table-2
-------
id--name--value
---------------
1--'no'--'no'
2--'yes'--'yes' -- Want to update this row as per the values from the table-1 for the id =2 from table-1

How can i do this?


Thanks,
Scarlet

[code green]

Want to update this row as per the values from the table-1 for the id =2 from table-1

How can i do this?

You can start by clarifying your question

[masdi2t]

Hi friends,
table-1
-------
id--name--value
-------------
1--'Test'--'Test'
2--'Testing'--'Testing'

table-2
-------
id--name--value
---------------
1--'no'--'no'
2--'yes'--'yes' -- Want to update this row as per the values from the table-1 for the id =2 from table-1

try this
UPDATE table-2, table-1 SET table-2.value = table-1.value
WHERE table-1.id=table-2.id AND table-2.id=2;

[pradeep kaltari]

Hi friends,


table-1
-------
id--name--value
-------------
1--'Test'--'Test'
2--'Testing'--'Testing'


table-2
-------
id--name--value
---------------
1--'no'--'no'
2--'yes'--'yes' -- Want to update this row as per the values from the table-1 for the id =2 from table-1

How can i do this?


Thanks,
Scarlet

You can also use this:
UPDATE TABLE-2 B
LEFT OUTER JOIN TABLE-1 A ON A.ID=B.ID WHERE A.ID=2