Win a copy of The Java Performance Companion this week in the Performance forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Which type of query should be use??

 
Ahamed Sharif
Ranch Hand
Posts: 47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic