Hi all !
I would like to update a table with a particular select like the following :

select c1,c2,c3 from tab1;
c1 c2 c3
-- -- --
1 10 100
2 10 100
3 10 100

select c1,c2,c3 from tab2;
c1 c2 c3
-- -- --
10 100
10 100
10 100
1 20 200

I would like to update c1 column in tab2 with the value of tab1 to obtain :

select c1,c2,c3 from tab2;
c1 c2 c3
-- -- --
1 10 100
2 10 100
3 10 100
1 20 200

Is there a simple way to do that with one update ?
Thanks a lot in advance !