View previous topic :: View next topic
|
Author |
Message |
ksmvali
New User
Joined: 05 Apr 2005 Posts: 4
|
|
|
|
Hi,
I need to update table values with another table values using SQL.
Help me please. |
|
Back to top |
|
|
ksmvali
New User
Joined: 05 Apr 2005 Posts: 4
|
|
|
|
Hi,
I need to update 8265 rows with another table values using SQL.
Help me please. |
|
Back to top |
|
|
ragshere
New User
Joined: 20 Dec 2004 Posts: 70
|
|
|
|
Hi,
what type of help you are expecting?
Rags |
|
Back to top |
|
|
raghunathns
Active User
Joined: 08 Dec 2005 Posts: 127 Location: rochester
|
|
|
|
update table1
set col1 = (select colx from tbl2 where tbl1col = tbl2col)
where <your condition for 8256 rows> |
|
Back to top |
|
|
ragshere
New User
Joined: 20 Dec 2004 Posts: 70
|
|
|
|
Hi,
use this
update table1 T1
set col1 = (select colx from tbl2 T2 where T1.col = T2.col)
where <your condition for 8256 rows>
it will go fine.
Thanks
Rags |
|
Back to top |
|
|
ksmvali
New User
Joined: 05 Apr 2005 Posts: 4
|
|
|
|
Thanks Rags |
|
Back to top |
|
|
Rameshs
New User
Joined: 15 Jun 2005 Posts: 53 Location: India, Chennai
|
|
|
|
Update table1 t1 set row=(select * from table2 t2 where t1.col=t2.col) |
|
Back to top |
|
|
|