What's wrong with this SQL query?

From: Paschal Mushubi <bs260_at_freenet.carleton.ca>
Date: 7 Feb 1999 15:56:46 GMT
Message-ID: <01be52cb$a0fe1f40$7f897586@paschalm>

What's wrong with this SQL?

select T1.Order_Date SEP,

        T2.Order_Date OCT
from Sales T1,

        Sales T2

where   T1.Order_Date between '01-SEP-98' and '30-SEP-98'
and     T2.Order_Date between '01-OCT-98' and '30-OCT-98'
and     T1.Dept_Number = T2.Dept_Number

It returns:

SEP         OCT
---         ---

09-22-98 09-22-98

I want to see

SEP         OCT
----        ----

22-SEP-98 15-OCT-98 What I am missing?

paschal. Received on Sun Feb 07 1999 - 09:56:46 CST