Bryan, the sql-guy, took a look at the query and proceeded to craft this response:
Book of SQL 24:17,
"Thou shalt not return many columns with an ORDER BY statement. If thou dost return too many columns, time shall progress, seasons shall change, before thou dost see thy results. Thou shalt consider rending apart a query of many columns, as the cloth is when sewn, into seperate queries. And some had said: 'the Supplier data was not needed in the Dataview, and so should have been queried only when creating the edit pop-up.' And those who said such a thing were considered wise."
--B. DeBois
"Thou shalt not return many columns with an ORDER BY statement. If thou dost return too many columns, time shall progress, seasons shall change, before thou dost see thy results. Thou shalt consider rending apart a query of many columns, as the cloth is when sewn, into seperate queries. And some had said: 'the Supplier data was not needed in the Dataview, and so should have been queried only when creating the edit pop-up.' And those who said such a thing were considered wise."
--B. DeBois
He later confessed that he's not really sure what the problem with the query was but following the above guideline more strictly did indeed resolve the problem. I would argue that at one time, before the project specs changed, the supplier data was needed in the dataview...but he's right because it's not needed anymore. In either case, two queries would probably be better, anyway.