I jumped the gun a little bit and am refining the selection tables and had to get permission to upload sample data. The target has changed as usual, but the...

Sorry about that, If you could can you remove and throw as far as possible. Its garbage. I will get back to you as soon as I can get my...

Hopefully this will work, if it is in the proper format I will continue with the other tables.

Please let me know, thanks Chris

Let me hash at it a bit.

Would I attach the sample tables or just paste into window?

The only common field is the SourceSiteID (GUID).Just a little background to the problem. From the Point or Poly location(PntSourcem_PlySourcem) a survey (PolyNPDESSurvey) can take place. This is signified by...

Thanks for the reply Chris, next time I will color code the sql statement.

The first query returns 531 rows, second 633, third 247 and the fourth 1454.

I was thinking if...

Sorry about that I am reading it now and wil post back with a more structured query, no pun intended.