[NBLUG/talk] OT - SQL query question

Eric Eisenhart eric at nblug.org
Fri Dec 2 12:00:41 PST 2005


On Fri, Dec 02, 2005 at 10:55:30AM -0800, Mark Street wrote:
> I would want the NAME and ADDR2, etc. fields as well as the DISTINCT field.  
> Actually my ADDR1 field contains the street number and name, not a biggie.  I 
> guess #2 below would come closest to my requirements.

Ahh...

You want:
SELECT DISTINCT ADDR1,field2,field3 from mydb

(no parens)
-- 
Eric Eisenhart
NBLUG Co-Founder, Scribe and InstallFest Coordinator
The North Bay Linux Users Group -- http://nblug.org/
eric at nblug.org, IRC: Freiheit at fn AIM: falschfreiheit



More information about the talk mailing list