Named Query multiple SLECT statements

Maker
,
1

I’m trying to append an existing named query that pulls from a MS SQL database table. They have a different number of rows and columns, the correlation is first dataset has a list of categories, and second set has hours logged information for those categories (not all). These SELECT statements work separately, but not together. I’m not sure what I’m missing here… thanks.

(SELECT
Scope_Categories.Category
,Scope_Categories.Hours_Total
,Scope_Categories.Hours_Remaining
FROM Scope_Categories
LEFT JOIN Scope_Categories ON Scope_Categories.Category = Eng_TimeLog.Project_Category
WHERE Scope_Categories.Num =:Num)

UNION ALL

(SELECT
DISTINCT Eng_TimeLog.Project_Category AS Category
,SUM(Eng_TimeLog.Hours) AS Hours_Logged
FROM Eng_TimeLog
RIGHT JOIN Scope_Categories ON Scope_Categories.Category = Eng_TimeLog.Project_Category
WHERE Eng_TimeLog.Project_Number = :Num AND Eng_TimeLog.Engineer_Name = :Name
GROUP BY Project_Category)

2

UNION ALL requires the same number of columns

3

And the same column types.