Thank you -SO- much. That's exactly what I was looking for. I haven't ever really used GROUP BY, and I didn't know you could add AND after an ON. Thank you so much. I'll be referencing this post again soon so I can keep in mind what you've showed me. I appreciate you breaking it down for me too with added advice, rather than just handing me a query.

You've saved me so many more headaches, and I learned something in the process. Thank you for your help.

It was complete, I just don't know if it works because I've been working on switching out all the pseudo code with my actual database information; and its confusing. My database already has all the data in it, so it's not like I can willy nilly add columns or delete them without going through hundreds of rows to add in new values.

Once I finally get all the information squared away I'll be happy to say if it works or not; in the mean time I'm leaving the door open for anyone else.

I do appreciate the work you did, thank you.
It's just not easy to implement it into my own environment, so I have no idea if it works or not yet.

modi123_1, on 27 September 2012 - 01:56 PM, said:

Thanks for the criticism and confidence boost.
You could have just been polite and said nothing if those were your thoughts.

Anyways, thank you for the reply; I'm still open to other answers however, if anyone has any.

I've never seen '-- used to comment out before, and I've also never seen # used before table names.
Is that new, out of curiosity?

I'm silly. I think I was working so hard last night I had a brain dead moment.

Thank you.

Thanks a lot for the reply. I feared that would be the case.

Looks like i'll be downgrading. I'm not going to dish out the cash for a VPS or DS before my project even has a line of my own code.

Just when I got everything working too!

Thanks again.