Does anyone know how to do a distinct count of 2 attributes from the same table?

I get an syntax error msg when I try to do this.

Thank you

As far as I know, you can't do something like this:

select count(distinct col1,col2) from table;

try this:

select distinct col1, col2 from table into temp temp_table with no log;
If you are working in dbaccess, you get the actual count after execution, if you are not:
select count(*) from temp_table;