Skip to Content
0
Former Member
May 01, 2014 at 07:57 PM

Syntax to add another table to join in command

27 Views

Can I add in another join to this select statement? like in red below

SELECT EDG.DX_ID,EDG.DX_NAME,EDG.CURRENT_ICD9_LIST, EDG_PAR.DX_NAME AS PARENT_NAME,EDG_PAR.PAT_FRIENDLY_TEXT

FROM CLARITY_EDG EDG INNER JOIN CLARITY_EDG EDG_PAR ON EDG.PARENT_DX_ID=EDG_PAR.DX_ID,

EDG_CURRENT_ICD9 INNER JOIN EDG ON EDG.DX_ID=EDG_CURRENT_ICD9.DX_ID

WHERE AAA.BBBB= 0100110