Hi folks, We're trying to work out what kind of calls and how many calls we get before 9am as management is considering moving our HelpDesk time from a 9am start to an 8:30am start(!) We've created some SQL along the lines of: SELECT id, create_time, FROM ticket WHERE HOUR(create_time) < 9; Which gives us 155 or so rows of data. However, how do I find out the Ticket Number for each of the ID and CREATE_TIME pairs returned? We've looked at the E-R diagram but are baffled! Any help much appreciated. Rajendrakumar Varsani Tel: 01904 455805 Department for Environment, Food and Rural Affairs (Defra) This email and any attachments is intended for the named recipient only. If you have received it in error you have no authority to use, disclose, store or copy any of its contents and you should destroy it and inform the sender. Whilst this email and associated attachments will have been checked for known viruses whilst within Defra systems we can accept no responsibility once it has left our systems. Communications on Defra's computer systems may be monitored and/or recorded to secure the effective operation of the system and for other lawful purposes.