when attempting to query three tables with this from and where clause,
FROM (select visitid,Diag_Code from tblInjury inj, luICD9 icd WHERE icd.Diag_Code *= inj.Injury_Code and icd.Diag_Code like 'E%')i, tblVisit v
WHERE i.visitid = v.visitid
I am receiving the following error.
'The table 'tblInjury' is an inner member of an outer-join clause. This is not allowed if the table also participates in a regular join clause.'
Is there a way around this?
FROM (select visitid,Diag_Code from tblInjury inj, luICD9 icd WHERE icd.Diag_Code *= inj.Injury_Code and icd.Diag_Code like 'E%')i, tblVisit v
WHERE i.visitid = v.visitid
I am receiving the following error.
'The table 'tblInjury' is an inner member of an outer-join clause. This is not allowed if the table also participates in a regular join clause.'
Is there a way around this?