combine multiple small queries into one single query

SELECT 1 as Combo, GoalQuadrantCd  as name, GoalTypeCd  as code, SomeDescription as label 
	FROM Table1

Union All

SELECT 2 as Combo, SourceSystemId as name, SubCd as code, HierarchyName as label
	FROM Table2 where SourceSystemId='YX'