need help in query

[milind199]

ASP_Customer

Customer_Id int(11) No auto_increment

Customer_Name varchar(30) Yes

Segment_Id int(11) Yes

SecurityApp_Id int(11) Yes

table ASP_Segment
Field Type Attributes Null Default Extra
Segment_Id int(11) No auto_increment

Segment_Name varchar(30) Yes

I want to insert new customer into customer table....

In my customer addition form i have drop down which will insert the customer in particular segment..This drop down is coming from database
.In any segment there will be only 20 customers i can add ...suppose in segment 1 i have added 20 customers then segment 1 will not be displayed in drop down .

i want to query the both database tables such that they will show me..correct options (segments)...every time when i am adding customer
it may be very simple but i was really stucked here....
I am not able to write exact query here....to fetch the values in drop down..

pls help....

-milind

[gyoung]

If I understand you, you want to select all segments linked to less than < 20 customers?

SELECT S.Segment_Id, Segment_Name
FROM ASP_Segment S
LEFT JOIN ASP_Customer A
ON S.Segment_Id = A.Segment_Id
GROUP BY S.Segment_Id, Segment_Name
HAVING COUNT(*) < 20

[milind199]

thanks Gary
it works for me....

As it may be very basic thing.... i have not worked with joins before...i am new to programming ....

this mailing list is really very good.
thanks again

-Milind