Developer forum

Hope this helps

SELECT        dbo.Statv2Session.Statv2SessionRefererUrl, dbo.Statv2Session.Statv2SessionRefererDomain, dbo.Statv2Session.Statv2SessionRefererTld, dbo.Statv2Session.Statv2SessionRefererSearchWord, 
                         dbo.Statv2Session.Statv2SessionRefererSearchWordRank, dbo.Statv2Session.Statv2SessionRefererSearchKeywords
FROM            dbo.EcomOrders INNER JOIN
                         dbo.Statv2Session ON dbo.EcomOrders.OrderVisitorSessionId = dbo.Statv2Session.Statv2SessionSessionId
WHERE        (dbo.EcomOrders.OrderCart = 1)

Hi Shiwanka,

Just what I needed.

Thank you very much!

Adrian