Thanks to everyone.Basically the trick was that I hadn't thought of JOINing tables which had no direct relationship. A kind of blind spot!
Thanks again.Giovanni