Union query sql...any ideas whats wrong?

[Steven.Foy]

Does anyone know whats wrong with this union query??????

I'm lost!

I want to join the two query results together[qry WD by Asset] and [qry WD Asset total other column]

SELECT [qry WD by Asset].[SumOfAnnualised Hours] AS [Annualised Hours], [qry WD by Asset].[Work Discipline] AS [Work Discipline],[qry WD by Asset].[SumOf<=1m] AS [<=1m], [qry WD by Asset].[SumOf>1m<=3m] AS [>1m<=3m], [qry WD by Asset].[SumOf>3m<1Y] AS [>3m<1Y], [qry WD by Asset].[SumOf1Y] AS [1Y], [qry WD by Asset].[SumOf>1Y] AS [>1Y], [qry WD by Asset].[Asset],

FROM [qry WD by Asset]

Union [ALL]

SELECT [qry WD Asset total other column].[SumOfSumOfAnnualised Hours] AS [Annualised Hours], [qry WD Asset total other column].[Other] AS [Work Discipline], [qry WD Asset total other column].[SumOfSumOf<=1m] AS [<=1m], [qry WD Asset total other column].[SumOfSumOf>1m<=3m] AS [>1m<=3m], [qry WD Asset total other column].[SumOfSumOf>3m<1Y] AS [>3m<1Y], [qry WD Asset total other column].[SumOf SumOf1Y] AS [1Y], [qry WD Asset total other column].[SumOfSumOf>1Y] AS [>1Y], [qry WD Asset total other column].[Asset],

FROM [qry WD Asset total other column]

ORDER BY [Annualised Hours] ASC;


HELP!