Need help on a query!!!

From: Jackie <jackie_ol_at_hotmail.com>
Date: 8 Oct 2002 22:51:10 -0700
Message-ID: <2c196db8.0210082151.32f567bc@posting.google.com>

Hi!
I have a table structured like shown below:

USERID               LOGIN_DATE
---------            ------------------
100200               10-11-2002
100200               09-08-2002
100200               10-11-2002
400300               05-06-2002
400300               05-06-2002
500200               01-01-2002
500200               02-02-2001
600100               01-08-2002

I want to write a query that returns a table like this:

USERID               LOGIN_DATE1          LOGIN_DATE2          LOGIN_DATE3
---------            -----------          -----------          -----------
100200               10-11-2002           09-08-2002           10-11-2002
400300               05-06-2002           05-06-2002
500200               01-01-2002           02-02-2001
600100               01-08-2002

Can anyone help me?
Thanks in advance... Received on Wed Oct 09 2002 - 00:51:10 CDT