this is working: mysql> select distinct pj from tmp; +-------+ | pj | +-------+ | 41857 | | 41992 | | 42620 | | HOLID | | OTHER | | PERS | | SICK | | VACAT | +-------+ 8 rows in set (0.00 sec)
now, i want to do something like this: mysql> select sum(hours) from tmp where pj=distinct group by month(period); does mysql support something like this? ************************************************************************** This e-mail and any files transmitted with it may contain privileged or confidential information. It is solely for use by the individual for whom it is intended, even if addressed incorrectly. If you received this e-mail in error, please notify the sender; do not disclose, copy, distribute, or take any action in reliance on the contents of this information; and delete it from your system. Any other use of this e-mail is prohibited. Thank you for your compliance. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php