dorianit
asked on
How to output another column in this query
The following query returns one column and one row with the Total. How do I display the EID column also?
SELECT Sum(Issue.Closed)+Sum(Issu e.Created) +Sum(Kana. Completed) AS Total
FROM Issue INNER JOIN Kana ON (Issue.DateTime = Kana.DateCompleted) AND (Issue.EID = Kana.EID)
WHERE (((Issue.EID)="E173495")) HAVING (((Issue.DateTime)>=#3/20/ 2014# And (Issue.DateTime)<#4/4/2014 #));
SELECT Sum(Issue.Closed)+Sum(Issu
FROM Issue INNER JOIN Kana ON (Issue.DateTime = Kana.DateCompleted) AND (Issue.EID = Kana.EID)
WHERE (((Issue.EID)="E173495")) HAVING (((Issue.DateTime)>=#3/20/
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.