Select * from [GLYEBalance] LEFT JOIN [GLPeriod]
ON ([GLYEBalance].[GLPeriodId] = [GLPeriod].[Id] and [GLYEBalance].[DBId] = [GLPeriod].[DBId])
where [GLPeriod].[Id] Is Null
or Not [GLYEBalance].[StartDate] = [GLPeriod].[StartDate]
or Not [GLYEBalance].[EndDate] = [GLPeriod].[EndDate]
