modify join clause for board manager info