Thanks for the initial suggestions everyone.

I tried removing the group by, and using an In instead of a Not in, isn't an option. I don't know all the actions,...

Jeff, I was finally able to take a look at this, and was able to modify what you provided to generate my results.

Thanks for your help.

Dan

Ok, Hopefully i have done this right. If it is incorrect let me know, and I will fix it.

--===== If the test table already exists, drop it

...

Ok, Thanks.

I will setup some data and information tomorrow. I appreciate your help so far.

Sorry i didn't get back to you earlier.

Unfortunately No i didn't work, I was receiving Most of the data for widget 1.

I'm trying to pull the data anytime the widget...