BIG THANKS to
Cadavre
Sudhakar Vallamsetty
with your help got the output wanted and started a new line of learning!
To anyone interested I went with the sub query method, but a massive shout to Cadavre for showing me a new way of doing things well explained!
Really appreciate the time guys
:-D:-D:-D:-):-)