SELECT @FieldList FROM (

--INSERT INTO #tempA
SELECT	A,B,C,D, ..., AB.*, BB.*
FROM SomeTable STable
LEFT JOIN	#tempB ON  ...
LEFT JOIN ...
LEFT JOIN ...
INNER JOIN ...
LEFT JOIN ...
WHERE BB.Value IS NULL
AND ...
AND ...
AND ...
AND ...
AND ... 

)