Again I did provide the code I did provide the error and I did attach a sample of the data that was returned. Please remove me from your forum....

And My Thanks is to Luis C he was very helpful without being Condescending! 🙂

Thats fine but we all have to learn somewhere and Im guessing you all were not born with the ability to do SQL. I am thinking you too had...

If you looked at my earlier post- I posted my query I posted the error message and i attached a sample of my data on my last post to the...

I still cannot get it to work I used this I put the ; after my select statement before your with statement and still get an error. I have...

thank you for the response I tried it and I get this Error Message:

Msg 319, Level 15, State 1, Line 3

Incorrect syntax near the keyword 'with'. If this statement is...

So I should just use Join then all the way? Thanks I will try that.