0908f969   
   From: reb01501@NOyahooSPAM.com   
      
   Harry wrote:   
   > I have a table with three columns:   
   >   
   > Name         Date           Action   
   > Fred           Today         this   
   > Fred           Today         this   
   > Fred            Today        that   
   > Wilma         Today         this   
   >   
   >   
   > I want to sort by name and by date, but only if 'this' was done more   
   > than once on the same day, and not if 'that' was done on the same   
   > day,They have to perform this more than once, and they cannot have   
   > performed that on the same day.   
   >   
   >   
   So the desired result from this sample data would be an empty resultset?   
   What do you want to display when the data actually contains rows that meet   
   your requirement? All the rows for that name and date? Or a single row for   
   that name and date?   
   Why don't you try again. Show us some sample data that includes data that   
   meets your requirements and then show us what you want the desired query to   
   return. The key being "show" - don't just describe the desired result: show   
   it to us.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)