Thanks again for the reply,
I am testing it as query now, eventually i'll have to put this part into a stored procedure
I agree with you Join practice and the comma separated is really outdated. But even after trying with that it doesn't give the desired output.