IQuery with Max Aggregate function not working???

pappad · **Joined:** Wed Sep 14, 2005 5:07 pm **Posts:** 6

I have been trying to make this IQuery work:

SELECT max(UserLogin.LoginDate) FROM UserLogin

But it returns more than one record. Actually, I get all the records in the UserLogin table.

What I'm in doing wrong? Help anyone?

KPixel · **Posted:** Mon Oct 10, 2005 9:18 am

Try

Code:

SELECT max(ul.LoginDate) FROM UserLogin ul

Guest · **Posted:** Mon Oct 10, 2005 5:32 pm

Thanks, it worked. I thought the table alias doesn't matter... I guess it does.

Again, Thanks