Reg: SQL Query..

[rhepsi]

hii...

i have 3 tables...
table 1, table 2 and table 3

now in table 1 i have st_code and st_sponsored_by fields..
st_sponsored_by is empty..

in table 2 i have sponsor_group_id_pk and sponsor_group_name

in table 3 i have st_sponsor_group_id_fk and sp_st_code


Now my requirement is such that...
I want the table 1. st_sponsored_by to be updated with the sponsor_group_name from table 2, where the table 1's st_code is same as sp_st_code in table 3
and table2.sponsor_id_pk = table3.sp_st_code


i want the update query for updating st_sponsored_by in table 1..

plz help...
thnx..
hepsi.

[Shashi Sadasivan]

hii...

i have 3 tables...
table 1, table 2 and table 3

now in table 1 i have st_code and st_sponsored_by fields..
st_sponsored_by is empty..

in table 2 i have sponsor_group_id_pk and sponsor_group_name

in table 3 i have st_sponsor_group_id_fk and sp_st_code


Now my requirement is such that...
I want the table 1. st_sponsored_by to be updated with the sponsor_group_name from table 2, where the table 1's st_code is same as sp_st_code in table 3
and table2.sponsor_id_pk = table3.sp_st_code


i want the update query for updating st_sponsored_by in table 1..

plz help...
thnx..
hepsi.

update table1
set table1.st_sponsored_by = table2.sponsor_group_name
from table2, table3
where table1.st_code = table3.sp_st_code
and table2.sponsor_id_pk = table3.sp_st_code

cheers

[rhepsi]

update table1
set table1.st_sponsored_by = table2.sponsor_group_name
from table2, table3
where table1.st_code = table3.sp_st_code
and table2.sponsor_id_pk = table3.sp_st_code

cheers

THNX.. so muxh.. it worked