Result:
1038651 2007-05-11 RMARTINEZ In-Service
1038651 2007-07-03 Equip Ret Pend Return Pending
1038651 2007-03-07 Import Returned
Query:
Expand|Select|Wrap|Line Numbers
- SELECT ticket_number, MAX(ticket_status_history.addedDate) AS OrderDate, MAX(ticket_status_history.Tech_id) AS Tech_id,max(description)
- FROM ticket_status_history WITH (NOLOCK)
- INNER JOIN ticket_status ON ticket_status.id = ticket_status_history.current_status
- WHERE
- ticket_number=1038651
- GROUP BY ticket_number, description, ticket_number