Hi everyone,
I got a problem translating a query from Oracle to Access 2010 because I don't know how to write the 'MINUS'.
I have to do the difference between two tables and I've tried using a 'LEFT JOIN' but I don't get the same result.
Basically, given two input values, the query has to show me a table with all the differences between these two tables.
Now I have this query:
SELECT value1, value2, value3, ...
FROM Table1 LEFT JOIN Table2
ON Table1.CODE = Table2.CODE
WHERE Table1.oldcode=[Please provide the oldcode:] AND Table2.newcode=[Please provide the newcode:]
As a result I get a table with more than 1.000 records but I'm expecting a table with 4 records.
Using the 'MINUS' statement on Oracle it works properly.
How can I do it?
Thank you
I got a problem translating a query from Oracle to Access 2010 because I don't know how to write the 'MINUS'.
I have to do the difference between two tables and I've tried using a 'LEFT JOIN' but I don't get the same result.
Basically, given two input values, the query has to show me a table with all the differences between these two tables.
Now I have this query:
SELECT value1, value2, value3, ...
FROM Table1 LEFT JOIN Table2
ON Table1.CODE = Table2.CODE
WHERE Table1.oldcode=[Please provide the oldcode:] AND Table2.newcode=[Please provide the newcode:]
As a result I get a table with more than 1.000 records but I'm expecting a table with 4 records.
Using the 'MINUS' statement on Oracle it works properly.
How can I do it?
Thank you