File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC query Problem Using MS-Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC query Problem Using MS-Access" Watch "JDBC query Problem Using MS-Access" New topic

JDBC query Problem Using MS-Access

shekar narayan

Joined: Mar 14, 2001
Posts: 3
Hi Guys,
Kindly help in getting the query sorted. I want the names of the fields of the AREA, ENGINEER and PROBLEM,which I am unable to it.
Thakns In Advance!

tables :
compid (int)custname,phoneno,doreg,intime,problem,area,engineer,outtime(alltext)
area : areaid, area(strings)
engineer : engid, engineer(text)
Peter den Haan
Ranch Hand

Joined: Apr 20, 2000
Posts: 3252

select a.area,, c.problem
from complaints c, area a, engineer e
where a.areaid = c.area and e.engid =
Is that wat you were looking for? Using "engineer" and "area" instead of "engid" and "areaid" in your complaints table is a bit confusing, by the way.
- Peter
I agree. Here's the link:
subject: JDBC query Problem Using MS-Access
It's not a secret anymore!