The sub-query returns the right number of rows. I had fixed the where clause when I tried your suggestion to use >= & <=.