[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 244
  • Last Modified:

Question about SQL formula in Crystal Reports XI

Hi,
I'm getting an error: "The multi-part identifier "PatientInfo"."PatientID" could not be bound."


... on this formula:

(SELECT "lu_OutcomeCode"."OutcomeCodeName"
FROM "VSD_ClinicalPathways"."dbo"."lu_OutcomeCode" "OutcomeCode" INNER JOIN "VSD_ClinicalPathways"."dbo"."PatientArrival" "PatientArrival"
ON "OutcomeCode"."OutcomeCodeID" = "PatientArrival"."PatientArrHOBNotMetCode"
WHERE  "PatientID" = "PatientInfo"."PatientID")

Not sure where I'm going wrong.

Thanks
0
jgerbitz
Asked:
jgerbitz
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
I think it must be PatientArrival.PatientID
0
 
jgerbitzAuthor Commented:
That took care of it, thanks.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now