![enter image description here](https://i.stack.imgur.com/Kemt8.png)

![enter image description here](https://i.stack.imgur.com/2pdDr.png)

Is there a way to triple check that the data is consistent between the three tables and show if there are any discrepancies in any of the three tables? 

Each table is not completely the same but they all have an `EmployeeID`, `amount`, `datepaid`, and `CID` column. 

When I did with two tables I thought I had the SQL as:

```
SELECT tbMaster.EmployeeID, tbMaster.Amount, tbMaster.DatePaid, tbMaster.CID
FROM tbMaster LEFT JOIN tbCID ON (tbMaster.CID = tbCID.CID) AND (tbMaster.Amount = tbCID.Amount) AND (tbMaster.DatePaid = tbCID.DatePaid)
WHERE (((tbMaster.[Advance/paid])="Paid Respondent") AND ((tbCID.CID) Is Null));

```

It worked but if the `tbCID` had any discrepancies it did not catch it...

So for the three tables I thought: 

```
SELECT tbMaster.EmployeeID, tbMaster.Amount, tbMaster.DatePaid, tbMaster.[Advance/paid], tbMaster.CID
FROM tbMaster, tbCID, table3
WHERE tbMaster.CID <> tbCID.CID
OR  table3.CID <> tbMaster.CID
OR  table3.CID <> tbCID.CID
OR tbMaster.Amount <> tbCID.Amount
OR  table3.AMOUNT <> tbMaster.AMOUNT
OR  table3.AMOUNT <> tbCID.AMOUNT
OR tbMaster.Datepaid <> tbCID.Datepaid
OR  table3.DATEPAID <> tbMaster.DATEPAID
OR  table3.DATEPAID <> tbCID.DATEPAID

```

But there is only 30 entries yet I get 5x or 6x copies and get over 30000 rows/entries in the query...