I had a small issue.
Can you pls check this...
I have two tables TABLEA,TABLEB.
TABLEA
--------------
col1 col2 col3
TABLEB
--------------
cl1 cl2 cl3
If col2 in TABLEA = cl2 in TABLEB,
then i need to update cl3 in TABLE B with col3 in TABLE A.
I tried running following queries but didnt work out.
QUERY1:
update TABLEB set b.cl3=a.col3 from TABLEA a,TABLEB b
where a.col2=b.cl2;
QUERY2:
update TABLEB set cl3=".cl3" where cl2 in
(select col2 as ".cl2",col3 as ".cl3" from TABLEA)
Can you suggest some way to proceed further.