Feb 04
Mike Dano How can I perform a search that returns only one match for each found value?
Feb 04, 2011; 19:21
Mike Dano
How can I perform a search that returns only one match for each found value?
I have the following records in a table:
> id favorite_flavor
> 01 chocolate
> 02 chocolate
> 03 vanilla
> 04 strawberry
> 05 chocolate
> 06 vanilla
How can I perform a search that only returns one match for each found value?
I want to do this through a normal search, not a portal.
The desired result would look like this:
> 01 chocolate
> 03 vanilla
> 04 strawberry
Thanks.
--
Mike
#############################################################
This message is sent to you because you are subscribed to
the mailing list <fmpro@lists.lassosoft.com>.
To unsubscribe, E-mail to: <fmpro-off@lists.lassosoft.com>
To switch to the DIGEST mode, E-mail to <fmpro-digest@lists.lassosoft.com>
To switch to the INDEX mode, E-mail to <fmpro-index@lists.lassosoft.com>
Send administrative queries to <fmpro-request@lists.lassosoft.com>
Feb 04
Corn Walker Re: How can I perform a search that returns only one match for each found value?
Feb 04, 2011; 20:56
Corn Walker
Re: How can I perform a search that returns only one match for each found value?
Feb 04
Mike Dano Re: How can I perform a search that returns only one match for each found value?
Feb 04, 2011; 21:19
Mike Dano
Re: How can I perform a search that returns only one match for each found value?
Feb 04
Bruce Robertson Re: How can I perform a search that returns only one match for each found value?
Feb 04, 2011; 19:33
Bruce Robertson
Re: How can I perform a search that returns only one match for each found value?