Thank you! That is exacly what I wanted just your answer works allot simpler than the way I went about solving this problem. Agian, thank you.

Well basically I wanted it to return all the license for the state. Then only tell me how many actual pilots I have in those states. So...

Okay here is the first table I tried to follow the codeing guidlines. Since I had created the tables as examples I had to do them by hand....

Thank you. Next time I will make sure that I do that. I figured out a solution to the problem. I can not use the Join

I...