Group by query

[anemoskkk]

SELECT Job.City, (COUNT(*) AS "JobsCount", (COUNT(NULLIF( TowedInformation.JobID<>Job.JobID, 1))) AS "FIXED"
FROM Job TowedInformation
GROUP BY Job.City


I was hoping this would have displayed

City JobCount Fixed
London 6 3
Liverpool 7 1

A syntax error comes up

Can someone tell me where I went wrong?

[orange]

Where did you find "NULLIF"?? I have Acc2003 so it may be valid in a newer version??
You are working with 2 tables Job and TowedInformation, so you need to identify them as 2 tables in your FROM.
You need some field to "join" the tables. What field is common to both Job and TowedInformation?
Your first COUNT does not have a closing )
FIXED is a reserved word so avoid it.

SELECT Job.City, (COUNT(*) AS "JobsCount" , (COUNT(NULLIF( TowedInformation.JobID<>Job.JobID, 1))) AS  "FIXED" 
FROM Job TowedInformation
GROUP BY Job.City

I'm not sure what fields and keys are really in your Tables, but the syntax will be something along these lines. I'm not sure how you were determining "FIXED" so you'd have to adjust for that.

SELECT Job.City
 , COUNT(*) AS JobsCount
XXXX  "FIXED " Stuff here XXXX
FROM 
Job 
,TowedInformation
WHERE
Job.JobId = TowedInformation.JobId
GROUP BY Job.City

Hope it helps.

Have you tried Google to find any samples or examples?
For SQL stuff you can look to http://www.w3schools.com/sql/default.asp