I am trying to link a query that is ran in another database to my current database. I really do not want to copy the query and its underlying tables over to my current database.
I have done it successfully by using : SELECT [Powertrain Surcharge].*FROM [Powertrain Surcharge] IN '\\vcn.ds.volvo.net\vpt-hag\proj09\011605\Country of Origin\2017 Calculations\Q3\Powertrain Cost Base\NAFTA 2017 PWT Q3.accdb';
However, my intent is to run a query off of this query. Every time I do, it crashes. (referenced database is closed)
In reading online, there is another way to do it, but I am not great at SQL code and I am not able to make heads or tails of it.
SELECT [predicate] { * | table.* | [table.]field1 [AS alias1] [, [table.]field2 [AS alias2] [, …]]} FROM tableexpression [, …] **[IN externaldatabase]** [WHERE… ] [GROUP BY… ] [HAVING… ] [ORDER BY… ] [WITH OWNERACCESS OPTION]
Does anyone know of a better way to do this? Or can anyone dummy down this code?
Thanks,
TB