Re: Problem with update

"Identity" <id_at_id.it> wrote in message
news:44afba4f$0$10064$4fafbaef_at_reader3.news.tin.it...
> I've a table "Table1" with:
>
> ID - Cod - Type - Value - Period
> 1-COD1-AAA-0-Jan
> 2-COD2-BBB-0-Feb
> 3-COD3-AAA-0-Feb
> 4-COD4-CCC-0-Feb
>
> Now I want to UPDATE this records using a Second Table "Table2"
>
> Type-Qt-Value-Period
> AAA-10-10-Jan
> AAA-3-2-Feb
> BBB-3-2-Feb
> CCC-4-6-Feb
> ....
>
> If, in table1, I've AAA I want to search in table2 the value of type AAA
> in
> the table1.period
> If, in table1, I've BBB I want to search in table2 the value of type BBB
> in
> the table1.period
>
>
> How Can I create this update??
>
> After the UPDATE, I would like to obtain:
>
> ID - Cod - Type - Value - Period
> 1-COD1-AAA-100-Jan (value = 10*10)
> 2-COD2-BBB-6-Feb (value = 3*2)
> 3-COD3-AAA-6-Feb (value = 3*2)
> 4-COD4-CCC-24-Feb (value = 6*4)
>
> Thanks

update table1
set value = (select qt*value from table2

                    where table2.type = table1.type
                    and    table2.period = table1.period)