Having a senior moment.........

I have a table with the following data

OWNER          DEPT
1                          A
1                          A
1                          A
2                          A
2                          B
3                          B
3                          B
3                          B
3                          C

and I need to get a count of how many departments there are for each owner

OWNER       NUM_DEPTS
1                        1     (A)
2                        2     (A/B)
3                        2     (B/C)

In VFP 9 I would do something like

SELECT aa.owner,COUNT(*) AS num_depts FROM (select DISTINCT owner,dept FROM myCursor) aa GROUP BY 1

but I'm having trouble remembering how to do this in one statement in VFP 8

All replies welcome.

Thanks............Rich