aspose file tools*
The moose likes JDBC 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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "JDBC query Problem Using MS-Access" Watch "JDBC query Problem Using MS-Access" New topic
Author

JDBC query Problem Using MS-Access

shekar narayan
Greenhorn

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!
Shekar


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

Joined: Apr 20, 2000
Posts: 3252

select a.area, e.engineer, c.problem
from complaints c, area a, engineer e
where a.areaid = c.area and e.engid = c.engineer
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: http://aspose.com/file-tools
 
subject: JDBC query Problem Using MS-Access
 
Similar Threads
JSP returning old data, database was changed correctly!
Display values form database
JSP two pages
SQL coding to add stock balance in JSP
web application in eclipse 9