kawi6rr (4/13/2016)
I'm sorry I tried to be as clear as I could but it looks like I could have explained better.Table
Is a table that's already created and filled with the data this was suppose to be an example of what I'm querying. I put it into code so the formatting was better.
Output
This was suppose to indicate the results I was looking for but I put it into code because of formatting.
Thanks for the reply it looks like you got what I was looking for.
The create table statement that I included, wasn't for you. You should have included it with your post so anyone can simply copy the code and have sample data to test.
The output was nicely formatted, but it seems that it wasn't related to the data you posted. Be sure to make the output match the sample data so we can validate before posting incorrect answers or spend more time trying to figure how to get to that result.
I'm glad that you got what you were looking for and I expect that you realized what was your mistake in the code. If you have questions, feel free to ask them so you don't have to resource to a forum every time you face a problem.