Cacher is the code snippet organizer for pro developers

select top 1000 hq.QuoteID
				,hql.QuoteLoadId
				,hq.CustomerGuid
				,tl.loadguid
				,tcl.customerguid
				,hq.CreatedDate as HorizonCreatedDate
				,tl.CreatedDate as OptimizerCreatedDate
from EchoQuote.Horizon.Quoteload hql
inner join EchoQuote.Horizon.Quote hq on hql.QuoteID = hq.quoteid
inner join EchoOptimizer.dbo.tblLoads tl on hql.loadid = tl.loadid
inner join EchoOptimizer.dbo.tblCustomerLoads tcl on tl.LoadGuId = tcl.loadguid