fixed join check
it works--transactions work. hoorah