Hi,
Here's a table of mine
name date changeDate
n1 d1 cd1
n2 d1 cd3
n2 d2 cd1
n4 d1 cd2
n1 d2 cd5
n5 d1 cd4
n6 d2 cd2
I need to select every name for which the changeDate
corresponding to d1 is greater than the changeDate
corresponding to d2. Any way I can use one statement
to do this?
Thank you very much.
Claire
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
