Table Differences

[David R]

So you got the combined query working?

 

[Jimbolya]

The combine query - no -
I have a meeting today with one of the engineers who works with the IPs that I tested this morning. See the challenge is that there's no single source of truth. I'm going to work with him to see what information he has and run that through the queries as well to find those differences. I'll probably want to do the combine query then...with his information and my information we should have a data set that's very accurate to the infrastructure.

However, now that I think of it, if I could get the frame work for the query up I could simply plug in what ever information I want to...
So i'm good to start working on the combine query any time lol.

 

[David R]

Don't forget...

I think we need to see the current SQL behind each of your three queries when you come back.

 

[Jimbolya]

Unmatched Old Query
SELECT [IIS Master Old 11 20 2013].Field1, [IIS ****** 11-20-2013].Field1
FROM [IIS Master Old 11 20 2013] LEFT JOIN [IIS ****** 11-20-2013] ON [IIS Master Old 11 20 2013].Field1=[IIS ****** 11-20-2013].Field1
WHERE ((([IIS ****** 11-20-2013].Field1) Is Null));

****** has been removed due to sensitive information. However, use this like you would normally use any other naming convention and i'll add back in the actual name for testing

Unmatched New Query
SELECT [IIS Master Old 11 20 2013].Field1, [IIS ****** 11-20-2013].Field1
FROM [IIS ****** 11-20-2013] LEFT JOIN [IIS Master Old 11 20 2013] ON [IIS ****** 11-20-2013].Field1 = [IIS Master Old 11 20 2013].Field1
WHERE ((([IIS Master Old 11 20 2013].Field1) Is Null));

 

[David R]

You still need to remove [IIS ****** 11-20-2013].Field1 from the SELECT line of UnmatchedOld. Remember, it's going to be null by definition (your WHERE clause)!

Same thing but in reverse for UnmatchedNew. Then try making your UNION query following steps in #3.

 

[Jimbolya]

So I met with another pier with regards to the different sources of information. Going to wait until I get out of a few meetings today to determine what lists are actually going to get compared lol.