I was trying to convert this query to ansi standard join statemet, but it is not giving the same record set waht did I miss
Code:
<html>
<head>
<title>query that should be converted</title>
</head>
<body>
SELECT eae.EAE_SES_ID
FROM PHOENIX.EXPEDITED_ADVERSE_EVENTS EAE
WHERE eae.EAE_SES_ID IN
(SELECT SES.SES_ID
FROM voyager.STUDY_VERSION_SITES ses
WHERE ses.SES_SVE_ID in
(SELECT sve.sve_id
from voyager.STUDY_VERSIONS sve
WHERE sve.sve_stu_id in
(SELECT sso.sso_stu_id
FROM voyager.STUDY_STAKEHOLDER_ORGANIZATIONS sso
WHERE (@VAR IS NULL or sso.sso_oty_id =@VAR)
)
)
)
</body>
<head>
<title>ansi-standard join statement</title>
</head>
<body>
SELECT eae.EAE_SES_ID
FROM PHOENIX.EXPEDITED_ADVERSE_EVENTS EAE INNER JOIN
voyager.STUDY_VERSION_SITES ses
ON SES.SES_ID = eae.EAE_SES_ID
INNER JOIN voyager.STUDY_VERSIONS sve
ON ses.SES_SVE_ID = sve.sve_id
INNER JOIN voyager.STUDY_STAKEHOLDER_ORGANIZATIONS sso
ON sve.sve_stu_id = sso.sso_stu_id
WHERE (@VAR IS NULL or sso.sso_oty_id =@VAR)
</body>
</html>