SELECT col1.NAME, temp.name
FROM DBName.sys.COLUMNS col1
JOIN DBName.sys.sysobjects ob ON ob.ID = col1.OBJECT_ID
AND ob.name =
‘Customer’
LEFT
JOIN(
SELECT col2.NAME
FROM DBName.sys.COLUMNS col2
JOIN DBName.sys.sysobjects ob2 ON ob2.ID = col2.OBJECT_ID
AND ob2.NAME =
‘Customer_Log’
)
AS temp ON temp.NAME = col1.name
