The folowing is a query I tried to do, to view reports that were between two dates, the problem is that the reports that are made on the second date, are not being display, if anyone can help me, please reply. thanks
select ticket.t_id, t_summary, t_category, e_status, t_department, e_assignedto, t_priority, t_timestamp_openend from ticket, events, tmpeid where ticket.t_id = events.t_id and events.e_id = tmpeid.e_id and t_timestamp_opened between 'yyyy-mm-dd' and 'yyyy-mm-dd'; 2,000,000,000 Web Pages--you only need 1. Save time with My Lycos. http://my.lycos.com --------------------------------------------------------------------- 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
