Thanks Jason, I think I'm almost there. My problem now is the query returns the gallery folder number not the name so I think I need a join on the other table & I think the title in that table is the folder name, is this correct to get the right path? Below is the query output & the number 6 should be the folder (I presume).
6/nina_782p.jpg
Can you help me a bit more to complete the join or syntax of the query?
Thanks Chris