select Tickets.ID as ID, Tickets.Priority as Priority, Tickets.SubmittedBy as SubmittedBy,Tickets.DateSubmitted as DateSubmitted,
Tickets.DateExpected as DateExpected, Tickets.LastActivity as LastActivity, Tickets.AssignedTo as AssignedTo, Tickets.Status as Status, Tickets.Subject as Subject from TroubleTickets as Tickets left join TroubleTicketNotes Notes on Tickets.ID = Notes.TicketID where Subject like '%Test%' or Notes.Note like '%Test%' group by Tickets.ID order by Tickets.Priority asc, Tickets.DateExpected asc