bopeavy, kramaswamy is right.

My query gives me the right result and you have the same. I am trying to avoid 2 joins that is all.

Thanks for the attempt. ...

Thanks Dixie Flatline ,

I will try this..

My Table1 is dynamic meaning it is table(x) the columns can be different since it may be from another table.

so, I cannot hard code...

I am not sure why nobody is posting replies but I found solution below.

declare @cols nvarchar(max), @sql nvarchar(max), @TableName varchar(10) ='Table1'

select @Cols = stuff((select ', ' + quotename(Column_Name)...