I have a SQL query that works as expected, and I turned it into a view. When I then query the view, I get a handful of records that are wrong, and I cannot figure out why. I have researched the issue and recreated the view, to no avail.