I really do have to thank you for taking the time to explain this to me. Great example and good job. I understand the concepts more from you and what I have been reading thru Tom Muck.
I will try out your example in the next day or so.
Can you still use the AS operator with the LEFT JOIN. That is the route I want to do since I want to see all campany options even if that option is not selected.
Again, thanks for your help.