If this really is your query, it's missing "INNER JOIN" and "ON" clauses. -----Original Message----- From: Jason Lustig [mailto:lustig at acsu.buffalo.edu] The query is this: SELECT b.name, b.email, bp.bpname FROM board b, board_position bp WHERE b.position=bp.id and b.chapter='99999'