List:General Discussion« Previous MessageNext Message »
From:Shaun Batterton Date:April 11 1999 2:25am
Subject:Re: BUG: query with 'group by' fails to find matching row[s] (fwd)
View as plain text  
Richard, I think the query you are interested in is:
select artist,filename from mp3 where full_path like '%mary%' ORDER BY
artist;


not your original query:
>select artist,filename from mp3 where full_path like '%mary%' group by 
>artist;
Thread
BUG: query with 'group by' fails to find matching row[s] (fwd)Richard G. Harman Jr10 Apr
  • Re: BUG: query with 'group by' fails to find matching row[s] (fwd)kalle volkov10 Apr
  • Re: BUG: query with 'group by' fails to find matching row[s] (fwd)Shaun Batterton11 Apr
    • Re: BUG: query with 'group by' fails to find matching row[s] (fwd)Richard G. Harman Jr12 Apr