This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
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