sql statement error

[nebchill26]

can i use the Count(*) function when i join 2 tables?

here's my sample code:

SELECT
tblServiceRecRequests.CtrNum,
tblServiceRecRequests.Pc_Name,
tblServiceRecRequests.Problem,
tblServiceRecRequests.ProblemType,
tblServiceRecRequests.Staff,
tblServiceRecRequests.ActionTaken,
tblServiceRecRequests.ServiceStat,

tblServiceRecords.DateRequest,
tblServiceRecords.RequestedBy,
tblServiceRecords.Department,
tblServiceRecords.Location,
tblServiceRecords.DateNeeded

FROM tblServiceRecords, tblServiceRecRequests
WHERE tblServiceRecords.CtrNum = tblServiceRecRequests.CtrNum
AND tblServiceRecords.CtrNum = '100000005'

[chazzy]

count() works on any select statement.

[sridhar_423]

if u want to select columns as well with count(), then the columns need to be part of your group by expression