View Single Post

   
  #1 (permalink)  
Old 03-01-2008, 03:49 PM
stockton
 
Posts: n/a
Default SELECT, GROUP BY & HAVING problem!

This is my TABLE

ID_1 ID_2 DAY MONTH
-----------------------------------------------
1 1 MON JAN
2 1 MON JAN
3 2 TUE FEB
4 2 TUE MAR

This is my SELECT STATEMENT

SELECT ID_2, DAY, COUNT(*) AS COUNT FROM `TABLE` GROUP BY `ID_2`,
`DAY` HAVING COUNT > 1

This RETURNS

ID_2 DAY COUNT
----------------------------------
1 MON 2
2 TUE 2

However, what I want to do is only return when there are multiple rows
(more than one) with ID_2 and DAY that match but where the MONTH is
different i.e. RETURN

ID_2 DAY COUNT
-----------------------------------
2 TUE 2

Any ideas?

Thanks in advance
Reply With Quote