Thanks guys, but it was definitely inner join I was needing. This has been resolved now anyway, thanks to some database restructuring and SQL malarkey, courtesy of the Mr Ian P Baker we all know and love. Well, we know him anyway.

Cheers