DISTINCT Question
| From: | Jeff Oien | Date: | Sun, 21 Apr 2002 01:10:17 +0000 |
| Subject: | DISTINCT Question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18703@lists.php.net to get a copy of this message | ||
How can I do a query for a distinct field plus get the info from
other fields? I tried this:
select DISTINCT email, name_first, name_last, id from applicants;
and it gave me everything. Thanks.
Jeff Oien