Combining tables
Posted: Tue Mar 16, 2004 1:03 pm
I have two tables:
A: 'x','y','attr'
and
B: 'x','y','ter','attr'
Both having same the same x and y's
I'm trying to insert the 'attr' from A to B
Something like
insert into B ('attr')
select 'attr' from A
But i cant make it work. It gets executed, but all 'attr' valueas in B are still 0
A: 'x','y','attr'
and
B: 'x','y','ter','attr'
Both having same the same x and y's
I'm trying to insert the 'attr' from A to B
Something like
insert into B ('attr')
select 'attr' from A
But i cant make it work. It gets executed, but all 'attr' valueas in B are still 0