How many records do you get when you run each of the following statements?

SELECT tblLevelToLevelRel.Active,changeddate,changedmachinename

FROM tblLevelToLevelRel INNER JOIN

TempDelete ON tblLevelToLevelRel.GenLevelToLevelRelID = TempDelete.genleveltolevelrelid

Select * from tblLevelToLevelRel