I want to run a query similar to the following
x
SELECT t.ticketid,
Min(oo.incidentid). max(t.createddate)
FROM (SELECT ticketid,
NAME,
createddate
FROM ticket) t
INNER JOIN (SELECT incidentid,
created,
date,
NAME
FROM oops) oo
ON t.ticketid = oo.incidentid
Now, when I run this query it tells me that for example, ticket id needs to be contained in either an aggregate function or the GROUP BY clause. However, when I add it at the and of the query, I still get
ticketid column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
What anyone tells me what I am doing wrong?
Advertisement
Answer
From what I can test this code :
SELECT t.ticketid,
Min(oo.incidentid) min_c,
max(t.createddate) max_c
FROM (SELECT ticketid,
NAME,
createddate
FROM ticket) t
INNER JOIN (SELECT incidentid,
created,
date,
NAME
FROM oops) oo
ON t.ticketid = oo.incidentid
group by t.ticketid
is OK. Check it please. Thanks! Here is the DEMO