>One query querying two different databases? I don't think you can do that.
I had three connection strings about local directories. So, I was able to pass the full path of the second directory I need in the INNER JOIN. So, I was able to resolve the issue with that. My research also found OPENROWSET() I could use when doing it against a SQL Server backend, for example.