Thanks Bygs
What I'm trying to do is show all Injury Codes from luICD9 with a count of visits from tblInjury with corresponding date from tblvisit. I need the outer join because There are Injury codes that have no visits.
Dennis
Here is a shortened version
SELECT case when Diag_Code = 'BLAH' then 'BLAH BLAH'
when Diag_Code = 'BAM' then 'BAM BAM'
else 'Unknow' END as Cluster,
COUNT(i.VisitID) AS Visits
FROM (select visitid,Diag_Code from tblInjury inj, luICD9 icd where icd.Diag_Code *= inj.Injury_Code and...
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...
Actually, what DrewConn says is not necessary. Once you have linked the SQL Server tables, you can change the name in Access to match you Access codes, providing you don't already have an existing Access table with the same name.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.