thanks everyone for your replies - that helps a lot but i do have another question.

it will probably seem dumb but i am (sort of) new to the concept of querying multiple tables in one query.  i know thats basic stuff but i just haven't had to to do that much until recently.

anyway -