Actually what he has below is the shortened version... Chris Blessing webguy at mail.rit.edu http://www.330i.net > > If this really is your query, it's missing "INNER JOIN" and "ON" > clauses. > > SELECT b.name, b.email, bp.bpname FROM board b, board_position bp WHERE > b.position=bp.id and b.chapter='99999' >