Hello. I have a query that's working properly on my home PC (Access 2010) but does not return any results at my work PC (Access 2010 and Access 2013). Any help would be appreciated.
The following query properly displays the 4th row of the Slave table on my home PC but not on my work PCs.
Code:
SELECT Slave.*, Slave.Primary, Slave.Secondary
FROM Master RIGHT JOIN Slave ON (Master.Primary = Slave.Primary) AND (Master.Secondary = Slave.Secondary)
WHERE (((Slave.Primary)<>[Master].[Primary]) AND ((Slave.Secondary)<>[Master].[Secondary]));
Top Table is Slave Table, Bottom Table is Master Table:
Primary |
Secondary |
Data |
A1 |
B2 |
AA |
A2 |
B2 |
BB |
A3 |
B3 |
CC |
A4 |
B4 |
DD |
Primary |
Secondary |
Data |
A1 |
B2 |
AA |
A2 |
B2 |
BB |
A3 |
B3 |
CC |