Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JavaRanch.com/granny.jsp
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

JDBC query Problem Using MS-Access  RSS feed

 
shekar narayan
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3252
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!