Need some urgent help in using UPDATE command in SQL

I have two tables:

Table Name: table1
Table Rows: a b

Table Name: table2
Table Rows: a b c d e f

Initially c of table2 is empty. I want to actually fill it up from
table1 using some statement like:

UPDATE table2 SET c={SELECT a FROM table1 WHERE b=d}

Where d belongs to table2.

Is this possible?

On Sat, 20 Oct 2007 05:36:58 -0000, Legend
<rahul986@gmail.com> wrote:

>I have two tables:
>
>Table Name: table1
>Table Rows: a b
>
>Table Name: table2
>Table Rows: a b c d e f
>
>Initially c of table2 is empty. I want to actually fill it up from
>table1 using some statement like:
>
>UPDATE table2 SET c={SELECT a FROM table1 WHERE b=d}
>
>Where d belongs to table2.
>
>Is this possible?

Just try it and you will know.
I think the braces should be parenthesis.
--
( Kees
)
c[_] Famous last words - Don't worry, I can handle it. (#441)