Copying data from one table to another
604542Feb 20 2008 — edited Feb 20 2008Table A
col1
col2
col3
col4
col5
col6
pk(col1,col2)
Table B
col1
col2
col3
col4
col5
col6
col7
col8
col9
pk(col1,col2)
I want to copy the columns col4,col5 and col6 from Table A into col4, col5 and col6 on Table B.
Can someone help with the query ? Its been a while and I can't seem to write what must be a basic query. I can
use the pk to join the tables but after that I'm having a mental block.