I need some help writing a SQL query involving several tables and a LEFT OUTER JOIN. In the interest of keeping posts to this list small, I have not included the question. If there is an SQL expert out there who is willing to help, please respond to me off list. I am using MySQL on Linux, Java servlets to access the database, and JSP to present the data. The problem is strictly with the syntax of my query and not the rest of the system. Thanks! Mark phillips@usa.net