Count Problem

[king_uk]

Hi,

I have got a problem with my count function.
I have two tables personal_details, sources.

Personal Details

Title
Name
Address etc...
source_id

Source

source_id
source

I want to create a query that shows the total number of customers entered with a specific source for example my result should show:

Source - Total

Source 1 - 2
Source 2 - 1
Source 3 - 5

"SELECT personal_details.*, source.source COUNT(source_id) FROM personal_details, source WHERE (personal_details.source_id=source.source_id) AND TO_DAYS(NOW()) - TO_DAYS(leaddate) <= 30 GROUP BY source_id"

Anybody Help?
Thanks

[laserlight]

It may be something like:

SELECT Source.source_id, COUNT(name) AS total
FROM Source, PersonalDetails
WHERE Source.source_id=PersonalDetails.source_id
GROUP BY Source.source_id

[king_uk]

There is a one to many relationship between personal_details.source_id and source.source_id

where one source can be assigned to many different customers.

[laserlight]

Yes, I misread it the first time round.