NicDX
SSC-Addicted
Points: 414
More actions
August 29, 2008 at 2:57 pm
#865290
Nevermind. Im being a moron!:blush:
Jack Corbett
SSC Guru
Points: 184395
August 29, 2008 at 3:00 pm
#865293
Yeah you are missing something obvious. You are joining on c.PR_PER_ADDR_ID and I think you want b.PR_PER_ADDR_ID. Check out the bolded code, I also italicized the aliases in question:
select
*
FROM
S_ADDR_PER a INNER JOIN
ContactDataMaskTemp b ON
a.ROW_ID = c.PR_PER_ADDR_ID NNER JOIN
S_CONTACT c ON
c.PER_TITLE_SUFFIX = b.CIFNUMBER collate Latin1_General_CI_AS
Jack CorbettConsultant - Straight Path SolutionsCheck out these links on how to get faster and more accurate answers:Forum Etiquette: How to post data/code on a forum to get the best help Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply