that was amazing, it worked thanks a lot.
-Nicholas I
On Thu, Oct 21, 2010 at 1:40 PM, Richard Huxton wrote:
> On 21/10/10 08:43, Nicholas I wrote:
>
>> Hi,
>>
>> there are two tables, table1 and table2, each having same column name
>> called sn_no,name. i want to update table1 names with table
On 21/10/10 08:43, Nicholas I wrote:
Hi,
there are two tables, table1 and table2, each having same column name
called sn_no,name. i want to update table1 names with table2 where sn_no
are same.
select * from table1;
sn_no | name
---+---
1 | ramnad
2 | bangalore
3
Hi,
there are two tables, table1 and table2, each having same column name called
sn_no,name. i want to update table1 names with table2 where sn_no are same.
select * from table1;
sn_no | name
---+---
1 | ramnad
2 | bangalore
3 | chennai
select * from table2;
sn_no
