>>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.
Could you briefly post some of the code? I'm still not sure what you're doing and how you coded it (I'm curious).
~~Bonnie