Thanks Dorian,

I found the issue, it was a typo in my SQL code that my SQL program overlooked.

This seems to be pretty trivial, but I can't make MS work with a query with a JOIN in it. I have searched the forum and the docs, and I have not found anything that refers to this scenario. My script has a couple of SQL queries using DBQUERY. The first works just fine and returns records. The second...