3.23.54 Thanks. Rhino <[EMAIL PROTECTED]> wrote: ----- Original Message ----- From: "Richard Reina" To: 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 A people that values its privileges above its principles soon loses both. -Dwight D. Eisenhower.