This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma 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