Hi
I have created the following sql statement (notice the commented code)
How do I incorporate the 2nd inner join in to the sql statement.
Sorry, just a newbie
SELECT
CON.new_VIPContactType,
CON.new_MembershipNumber AS 'Member ID',
CON.AccountIdName AS 'Company',
CON.FirstName AS 'First Name',
CON.MiddleName AS 'Middle Name',
CON.LastName AS 'Last Name',
CONVERT(varchar,CON.BirthDate,101) AS 'DOB',
CON.GenderCode AS 'Gender',
CON.new_VIPUserType AS 'User Type',
CON.EMailAddress1 AS 'E-mail',
CON.FullName AS 'Member Name',
CON.new_CoverageType AS 'Plan Type 1',
CON.new_VIPPlanType AS 'Plan Type',
CON.new_VIPProductName AS 'Product Name',
CONVERT(varchar,CON.new_MemberSince,101) AS 'Effective Date',
SMB.Value AS 'Location Value'
FROM dbo.Contact CON
INNER JOIN dbo.StringMap SMB
ON CON.new_address1_province = SMB.AttributeValue
WHERE SMB.AttributeName = 'new_address1_province'
AND SMB.ObjectTypeCode = 10007
AND SMB.LangId = 1033
/*
JOIN dboStringMap SMB1
ON CON.new_CoverageType = SMB1.AttributeValue
WHERE SMB1.AttributeName = 'new_coveragetype'
AND SMB1.ObjectTypeCode = 2
AND SMB1.LangId = 1033
*/
AND CON.StatusCode = 1
