join testing bug fixes
updating join to conform closer to sqlite