Need you help to debug an SQL query (2008 R2).
It only references five tables but has some slightly tricky joins !
So I just need some help getting the syntax correct - I can test or can supply backup of the database if necessary
Here it is:-
Select [login to view URL] AS oRef, [login to view URL] AS oName, [login to view URL] AS oAddr1, [login to view URL] AS oAddr2, [login to view URL] AS oAddr3,
[login to view URL] AS oAddr4, [login to view URL] AS oAddr5, [login to view URL] AS oCountry, [login to view URL] AS oDX, [login to view URL] AS oeMail, [login to view URL] AS oTel, [login to view URL] AS oFax, [login to view URL] AS oMob, [login to view URL] AS oAKA, [login to view URL] AS oPortal, [login to view URL] AS oWWW, [login to view URL] AS oSkype, [login to view URL] AS oAcc, [login to view URL] AS oBal, [login to view URL] AS oCR, [login to view URL] AS oVAT, [login to view URL] AS oCur, [login to view URL] AS tDesc, [login to view URL] AS oDDAccName, [login to view URL] AS oDDAccNo, [login to view URL] AS oDDSort, [login to view URL] AS oDDBankRef, [login to view URL] AS oDDAmount, [login to view URL] AS oDDDom, [login to view URL] AS oDDStatus, [login to view URL] AS oAnal1, [login to view URL] AS oAnal2, [login to view URL] AS oAnal3, [login to view URL] AS cRef, [login to view URL] AS cName, [login to view URL] AS cJob, [login to view URL] AS cAddr1, [login to view URL] AS cAddr2, [login to view URL] AS cAddr3, [login to view URL] AS cAddr4, [login to view URL] AS cAddr5, [login to view URL] AS cCountry, [login to view URL] AS cDX, [login to view URL] AS ceMail, [login to view URL] AS cTel, [login to view URL] AS cFax, [login to view URL] AS cMob, [login to view URL] AS cFormal, [login to view URL] AS cInformal, [login to view URL] AS cAKA, [login to view URL] AS cPortal, [login to view URL] AS cWWW, [login to view URL] AS cSkype, [login to view URL] AS cAcc, [login to view URL] AS cBal, [login to view URL] AS cCR, [login to view URL] AS cVAT, [login to view URL] AS cCur, [login to view URL] AS cDDAccName, [login to view URL] AS cDDAccNo, [login to view URL] AS cDDSort, [login to view URL] AS cDDBankRef,
[login to view URL] AS cDDAmount, [login to view URL] AS cDDDom, [login to view URL] AS cDDStatus, [login to view URL] AS cAnal1, [login to view URL] AS cAnal2, [login to view URL] AS cAnal3, [login to view URL] AS cSur, [login to view URL] AS cFore, [login to view URL] AS cTit FROM RELATE r
Left OUTER JOIN Terms t ON [login to view URL] = [login to view URL]
INNER JOIN LOCALSALESNAMES o ON ([login to view URL] = 'ORG', [login to view URL] = [login to view URL]) OR ([login to view URL] = 'ORG', [login to view URL] = [login to view URL])
INNER JOIN CONTACTS c ON ([login to view URL] = 'CON', [login to view URL] = [login to view URL]) OR ([login to view URL] = 'CON', [login to view URL] = [login to view URL])
WHERE [login to view URL] = 'ORG' and fldFromID in (Select [login to view URL] from LOCALSALESNAMES o WHERE [login to view URL] IN (SELECT fldRef FROM OrgCatData WHERE fldOrgCatRef IN (6))) AND [login to view URL] = 'CON' and fldToClass in (Select [login to view URL] from CONTACTS c WHERE [login to view URL] IN (SELECT fldReccID FROM MailCatData WHERE fldMailCatRef IN (29))) OR ([login to view URL] = 'CON' and fldFromID in (Select [login to view URL] from CONTACTS c WHERE [login to view URL] IN (SELECT fldReccID FROM MailCatData WHERE fldMailCatRef IN (29))) AND [login to view URL] = 'ORG' and fldToID in (Select [login to view URL] from LOCALSALESNAMES o WHERE [login to view URL] IN (SELECT fldRef FROM OrgCatData WHERE fldOrgCatRef IN (6)))