> How can I get a select-in-the-from clause to work? I mean
> something like:
>
> select count(*) from (select distinct sample_type from samples)
>
> Any help will be appreciated :o)
>
> Regards,
>
> J

Do you mean
select sample_type, count(*) from samples group by sample_type

Alan