On Fri, Feb 10, 2006 at 11:59:30AM -0800, Bill Moseley wrote: > How do I make a join on the class table but not effect the left outer > join? Are you looking for something like this? LEFT OUTER JOIN (class INNER JOIN class_domain ON ...) c ON ... -- Michael Fuhr