[NBLUG/talk] OT - SQL query question

[Dean A. Roman]

Mark,

  Adding fields on the select line will give you the additional fields 
your looking for.

Example:  " select distinct(log_id),log_date,log_msg from phpgw_log; "

Thanks,
   ---Dean.



Scott Doty wrote:

>On Fri, Dec 02, 2005 at 10:12:19AM -0800, Mark Street wrote:
>  
>
>>This is slightly off topic.  I have an old dBase database with 12000 records.  
>>There are some records with the same address field.  I need to strip out the 
>>DISTINCT address records into a separate database.
>>
>>SELECT DISTINCT ADDR1 FROM MYDB gets me the unique addresses but I need the  
>>other fields as well.
>>
>>What would be the best way to do this?
>>    
>>
>
>Hi Mark,
>
>I may be wrong, but I think you can just list the other fields that you
>want...e.g.:  select distinct(ADDR1),field2,field3 from mydb ...
>
>I haven't tried it, but that would be the first thing I'd try...
>
> -Scott
>
>_______________________________________________
>talk mailing list
>talk at nblug.org
>http://nblug.org/cgi-bin/mailman/listinfo/talk
>
>
>  
>

E-mail: droman at romansys.com
Web   : http://www.romansys.com