I have one table (Table1) that has several columns used in combination: Name, TestName, DevName, Dept. When each of these 4 columns have values, the record is inserted into Table2. I need to confirm that all of the records with existing values in each of these fields within Table1 were correctly copied into Table 2. 

I have created a query for it:

```
SELECT DISTINCT wr.Name,wr.TestName, wr.DEVName ,wr.Dept
FROM table2 wr
where NOT EXISTS (
SELECT NULL
FROM TABLE1 ym
WHERE ym.Name = wr.Name 
          AND ym.TestName = wr. TestName
          AND ym.DEVName = wr.DEVName 
          AND ym. Dept = wr. Dept 
          )

```

My counts are not adding up, so I believe that this is incorrect. Can you advise me on the best way to write this query for my needs?