List:General Discussion« Previous MessageNext Message »
From:Rhino Date:January 5 2006 3:43pm
Subject:Re: SELECT help.
View as plain text  
----- Original Message ----- 
From: "Richard Reina" <richard@stripped>
To: <mysql@stripped>
Sent: Thursday, January 05, 2006 10:29 AM
Subject: SELECT help.


> Can someone help me write a query to tell me the  customer numbers (C_NO) 
> of those who've had more than 4 transactions  but none in the last 6 
> months?
>
>  |   transactions_table                             |
>  | ID    |    C_NO    |    DATE       |   AMOUT|
>  |2901| 387            |"2003-10-09"|        23.00|
>
>
>  Obviously my table has many more entries.
>
>  Thank you for any help.
>
What version of MySQL are you using? I would give a different answer if you 
had a version that supported subqueries than if you were using an older 
version that didn't support them.

Rhino 



-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.13/221 - Release Date: 04/01/2006

Thread
SELECT help.Richard Reina5 Jan
  • Re: SELECT help.Rhino5 Jan
    • Re: SELECT help.Richard Reina5 Jan
    • Re: SELECT help.SGreen5 Jan
      • Re: SELECT help.Richard Reina7 Jan
  • Re: SELECT help.Michael Stassen5 Jan
  • Re: SELECT help.James Harvard5 Jan
  • Re: SELECT help.Peter Brawley5 Jan