Hopefully this helps understand what I am asking.

SELECT [t].[TicketID] as "Ticket"

,

.[TicketHistoryID]

,[ac].[STR_ACCOUNT_NUMBER]

,[om].[body]

,[t].[TicketBoxID]

,[tb].[Name] as "Ticket Group"

,[g].[GroupName]

,[t].[Subject]

,[t].[Contacts]

,[t].[DateCreated]

FROM [Emails].[dbo].[Tickets] [t]

left outer join

[Emails].[dbo].[TicketBoxes] [tb] on [t].[TicketBoxID] = [tb].[TicketBoxID]

left outer join

[SYS_Live].[dbo].[ACCOUNT] [ac]

on [t].[Contacts] collate SQL_Latin1_General_CP1_CI_AS

= [ac].[STR_EMAIL_ADDRESS] collate SQL_Latin1_General_CP1_CI_AS

left outer join

[SYS_Live].[dbo].[vwAPPS_SUMMARY] [vwapp]

on [t].[Contacts] collate SQL_Latin1_General_CP1_CI_AS

= [vwapp].[STR_EMAIL_ADDRESS] collate SQL_Latin1_General_CP1_CI_AS

Where

[t].[datecreated] between '05-29-2013' and '05-30-2013'

and

.[TicketBoxID]in ('154','155','156','158','160','165')

and [om].[body] not like '%auto-%'

Order by [t].[DateCreated] desc