Someone

SELECT @FieldList FROM (--INSERT INTO #tempASELECT	A,B,C,D, ..., AB.*, BB.*FROM SomeTable STableLEFT JOIN	#tempB ON  ...LEFT JOIN ...LEFT JOIN ...INNER JOIN ...LEFT JOIN ...WHERE BB.Value IS NULLAND ...AND ...AND ...AND ...AND ... )