Pro*C COUNT -need help!

I need to do a count that would do the following:

assuming tables:

A

   ID F_Name L_Name Num

    1       A      B   3
    1       A      A   2
    1       A      C   6
    1       A      B   1

How do I do a count that would produce the desired results?

SELECT COUNT(DISTINCT ID, F_NAME, L_Name) FROM A
WHERE ID = 1; I guess after I do the WHERE ID = 1 all that I would need is a count of the distinct combinations of F_Name and L_Name. I know the above DISTINCT is wrong...

I am able to do this in SQL*Plus, but NOT in the Pro*C:

SELECT COUNT(*)
FROM (SELECT DISTINCT F_Name, L_Name FROM A WHERE ID = 1);

This (I think works), but Pro*C doesn't allow a subquery in the FROM clause.

If anyone can help that would be GREAT!!!! TIA

-- 


******************************************************************************

**  Eric R. Lapp                                 E-Mail:  erlst3+_at_pitt.edu  **


******************************************************************************