table definitions are

SELECT 'A' AS COL1,'B' AS COL2,'C' AS COL3,'D' AS COL4 INTO #TABLE1

UNION ALL

SELECT 'A' , 'B','C','D'

UNION ALL

SELECT 'A' , 'B','C','F'

UNION ALL

SELECT 'A' , 'B','C','F'

SELECT 'A' AS COL1,'B'...