Hello, I have table with messages, and i have users table, the are linked via PK UserID -> UserID, what i need is to select Messages for current month and calculate top 5 posters list for current month.
I have create following query but it's not complete: SELECT Handle, Screen_Name from MBoard where Message_Date>='2003-11-00' ORDER BY Handle; this gets me all messages posted this month ordered by userid Thank You. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
