Which type of query should be use??

[Ahamed Sharif]

Hi,
Is it posible to insert single colume value from one DSN table to
another DSN table.
table: DSN1
Name Adrress City
aaa bbbb xxx
ccc sss yyy
table: DSN2
Phone Job City
eee ttt
qqq kkk
Finally the DSN2 table look like
table: DSN2
Phone Job City
eee ttt xxx
qqq kkk yyy
Any sql quely like inserting DSN1table City values into DSN2table
City.
I used this query but giving some problem
"insert into UserInfo (CITY) in 'C:\\User.mdb' select CITY from RateInfo";
its inserting the city value but remailning null, I mean not in a perticular row.
Help would be appriciated.
Thanks,
Ahamed.