Re: Displaying distinct rows in Forms 4.5 block?

igal_at_healthstreet.com wrote:
>
> Hello everybody,
> My block is based on several fields from a view. However, I'm displaying only
> 3 of those fields. (I use the others in the WHERE clause) Is there a way to
> show only distinct occurences of those 3 fields?
> Thanks,
> Igal
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading

Change the view. You don't have to select the fields that you want to use in the where clause:
select distinct field1

,      field2
,      field3

Joep Received on Fri Jun 05 1998 - 13:49:33 CEST