aspose file tools*
The moose likes JDBC and the fly likes Which type of query should be use?? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Which type of query should be use??" Watch "Which type of query should be use??" New topic
Author

Which type of query should be use??

Ahamed Sharif
Ranch Hand

Joined: Aug 24, 2003
Posts: 47
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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Which type of query should be use??
 
Similar Threads
mysql & incomplete insertions!
Which SQL Statement should use for that??
Any one have idea regarding this query??
Which type of query should be use??
Problem with SQL uqery or DSN