>I need a count of all records where my sql is looking at three distinct fields:
>
>Select Count(Distinct f1, f2, f3) From table1 Where mydate > startdate
>
>Thanks for the help.
select count(*) from (select distinct f1,f2,f3 from table1 where mydate>startdate) as temp1
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________