i have a main query that it gets data form 2 other queries and inner join relation between these 2 other queries. when i am working in microsoft Access front-end and Access back-end i have no problem.
now after migration tables to sql server i wanted to change this main query to pass-through query. after changing that to pass-through query i got error "sql server driver invalid object name query name".
how i have to solve this problem. all the data for pass-through must come from tables? it does not work with other queries that before migration was working?
please.