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