https://ibb.co/mgP3gF[/url]
https://imgbb.com/
Last problem on my SQL problems. He always puts something in we haven't gone over yet to make us think. I tried using nested queries and a case function. I have an idea of what needs to be done, just looking for a little direction. Thanks as always!

This post was edited by Zom8 on Feb 6 2017 08:28pm

it seems like you just need a join clause.

Joins are like the clause to know for sql, but they can be kind of confusing at first with all the different kinds. But you can find plenty of good examples of how to use them online.

yes I figured it out. I used a natural join with some was statements. Thank you though for the interest!