I cannot run your query with the tables you provided.  if you run Select *  you should see all column from all  tables. compare those rows, you should be able find the different value in same column.