
March 15th, 2005, 11:44 AM
|
|
Registered User
|
|
Join Date: Jan 2005
Posts: 3
Time spent in forums: 2 m 51 sec
Reputation Power: 0
|
|
|
Basic statement implementing another where statement
Hi i have this sql statement and want to incorporate another where statement which basically says
WHERE consultant_jobtypes.con_id >= 2,
basically i want to filter this out then from the remaining result see who has a job id over only 2
SELECT consultant_jobtypes.con_id, Count(consultant_jobtypes.con_id) AS CountOfcon_id
FROM consultant_jobtypes
WHERE (((consultant_jobtypes.job_id) In (1,3)))
GROUP BY consultant_jobtypes.con_id;
any ideas?
thanks again
|