CREATE PROCEDURE viewJobsa1 AS
SELECT distinct
a.InternalNumber,
a.JobID,
a. JobTitle,
a.PostedDate,
b.Category,
a.State,
COUNT( c.ApplyJobNumber) as jobHits,
SUM(d.Hits) as HitsNum
FROM
Jobs a left outer join Category b on a.CategoryID = b.CategoryID
left outer join ApplyJobs c on c.ApplyJobNumber = a.InternalNumber
left outer join JobImpression d on d.InternalNumber = a.InternalNumber
WHERE
b.clinical = '1' AND a.clinical='1'
GROUP BY a.InternalNumber, a.JobID, a. JobTitle, a.PostedDate, b.Category, a.State, c.ApplyJobNumber, d.Hits
GO
I problem je sledeci.
Treba da iz table APPLYJOBS izvucem i count-ujem broj applikacija i iz ove druge table ta izvucen i saberem broj HIT-hitova, ali ne radi.. :(
Gdje grijesim da li neko zna..