>> SELECT name, update, boardpic FROM chapter WHERE id=99999 >> Not sure whether that 'update' will cause a problem. > [...] the above works where [...] "SELECT b.name, b.email, > bp.bpname FROM board b, board_position bp WHERE b.position=bp.id and > b.chapter='99999'" doesn't Try ... FROM board AS b, .... Regards Mark Howells <http://www.mark.ac/evl>