Help with sql query

[eluser]Unknown[/eluser]
Thank you so much for your replies and your time .
rufnex your solution worked.. Thankyou .

CroNix also thankyou for your advice. I had a feeling a join was the way to fix it, but I still find joins very hard to grasp with my sql abilities .