hi all
i got problem reading multiple table from ms access using jdbc. i read two table from one class but i got 12 table to read. so how can i do dat? any help will be great
thank you
emint
0
Junior Poster in Training
Recommended Answers
Jump to PostBy adding more queries?
If you mean you have "12" "mdb" files to read, then open 12 connections. If you mean you have to read information from multiple tables within the same "mdb" file, then add additional queries for them. If you need the data from all the tables …
Jump to PostBecause, like I said, a "join" in the where clause of your SQL query is a much better way to do it (you only need one query), and the construction of that query (as it is an SQL query) is an SQL question and not a Java question.
Jump to Postselect table1.field1, table1.field2, table2.field1 from table1, table2 where table1.field3 = table2.field5
Again, this is an SQL question.
All 11 Replies
masijade
1,351
Industrious Poster
Team Colleague
Featured Poster
emint
0
Junior Poster in Training
emint
0
Junior Poster in Training
masijade
1,351
Industrious Poster
Team Colleague
Featured Poster
emint
0
Junior Poster in Training
masijade
1,351
Industrious Poster
Team Colleague
Featured Poster
emint
0
Junior Poster in Training
masijade
1,351
Industrious Poster
Team Colleague
Featured Poster
emint
0
Junior Poster in Training
masijade
1,351
Industrious Poster
Team Colleague
Featured Poster
emint
0
Junior Poster in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.