Query result incorrect when using SQL-server tables (ODBC)
Posted on 2001-07-24
We are using Access and SQL-server. We have found a problem in the result of the queries. I will describe the situation:
We create a query that uses two tables of SQL-server via ODBC. The link between the tables is an outer join because not all items of the first table exists in the second table. The result is that only the items that exists in both tables will be displayed (strange!! It should be all items of the first).
We are sure that the query is correct and that there is a problem with the system, ODBC-driver or something because if we run the same query on another computer and the result is correct (all items of the first table).
Maybe it is an already known bug but we can't find a solution now.