David Burrows, you are a life saver.

I'm doing the joining to the dataset, acting as a table.

I'm not a beginner to SQL, but this trick was definitely not in my toolbox.

Also, thanks Pete, both of you have helped me out tremendously getting over this hurdle, it's been one of those things where I've stared at it for so long I wasn't seeing all the options out there.

I'll post again if I run into anymore issues, thanks guys.