If whole records are missing then your sub queries aren't the problem. How many records are there in tblAKDAccount? That is the number you're latest query should return.