Thanks everyone. Having tried the inner join in place of the left I still found my desired output. Thank you very much. 🙂

cheers that worked a treat 🙂

Thanks alot, I'll look into that. Really appreciate your help.