Re: DISTINCT and multiple results...
| From: | Torsten Roehr | Date: | Mon, 07 Jun 2004 13:50:15 +0000 |
| Subject: | Re: DISTINCT and multiple results... | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34669@lists.php.net to get a copy of this message | ||
"Tristan Pretty" <Tristan.Pretty@risk.sungard.com> wrote in message
news:OFF5A16147.3B9CBF28-ON80256EAC.0047E40E-80256EAC.0048F1F2@risk.sungard.
com...
> Ah, but then how can I select other info from the same table (title, first
> name, company etc...)
Just add all the required fields to your select statement:
SELECT DISTINCT email, title, company FROM table
Regards, Torsten Roehr