Hi All,
My client has a need for a report that invovles me doing some cross database joining.
I am using it in the custom view, so that it doesnt make a view on the database, there are reasons why I cannot do that.
When I put the query in the database, it works. When I put it in the custom view, and run it, it works, but when I click ok, to save it, it gives me an error saying that the table that I am trying to access from the other database, does not exist in this database.
Its as if its looking for it in the projects database, but I am fully referencing the table like so: INNER JOIN dbname.tblname dt ON dt.FIELD=ot.FIELD where ot is a table on the local database.
Any help is greatly appreciated.
Thanks in advance,
Zedd