I have a program where I'm attempting to execute a SQL query that references a table that exists on another database. It's the last line before the "if":
Sql = Sql & "FROM CCLCache.dbo.CustomersExported)"
It's giving me the error "invalid object name" for that table, but I know it exists in that database. What more do I need?