Re: DISTINCT and multiple results...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Tristan Pretty" <Tristan.Pretty@xxxxxxxxxxxxxxxx> wrote in message
news:OFF5A16147.3B9CBF28-ON80256EAC.0047E40E-80256EAC.0048F1F2@xxxxxxxxxxxxx
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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux