had a primary key mixed up on the join query