UPDATE (SELECT t1.col1 c1, t2.col1 c2 FROM table1 t1, table2 t2

how can we replace the particular column value of a resulted
set of executed query? I mean write down a sql query to
chane the particular column's value of a resulted set of
executed query

Question Posted / mglbayar

3 Answers
6320 Views
I also Faced
E-Mail Answers

Answer Posted / mglbayar

UPDATE (SELECT t1.col1 c1, t2.col1 c2
FROM table1 t1, table2 t2
WHERE t1.pk = t2.fk AND more_condition)
SET c1 = c2;

Is This Answer Correct ?

2 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is trigger in sql and its types?

992

how to convert character strings to numeric values? : Sql dba

1027

what is dbms? : Sql dba

934

What's the procedure?

871

What are triggers and its types?

998

Write the alter statement to enable all the triggers on the t.students table.

1070

What is full form of rtm?

957

How would you pass hints to the sql processor?

924

What is parameter substitution in sql?

977

How to display Row Number with Records in Oracle SQL Plus?

993

What is the need of a partition key?

944

What are the different dml commands in sql?

1091

What is string data type in sql?

1055

what is 'mysqlcheck'? : Sql dba

960

What is identity column in sql server?

988