Multi-part Identifier could not be found

[Ananias]

hello everyone,

Please consider the following SQL script -

use PatientCare
go
select pr.PatientId, p.FirstName,p.LastName, m.Name 
from Prescription as pr inner join Patient as p inner join Medicine as m
on p.PatientId = pr.PatientId 
on pr.MedicineCode = m.MedicineCode;

For this SQL script, I get the error messages - "multi-part identifier could not be found"

Please help,,,,,,,

[Modifier]

Do it this way -

SELECT pr.PatientID, p.FirstName, p.LastName, m.Name
FROM Prescription pr 
JOIN Patient p ON p.PatientID = pr.PatientID
JOIN Medicine m ON pr.MedicineCode = m.MedicineCode

or you can do it this way -

SELECT pr.PatientID, p.FirstName, p.LastName, mName
FROM Prescription pr, Patient p, Medicine m
WHERE p.PatientID = pr.PatientID AND pr.MedicineCode = m.MedicineCode

[Katty]

hey Ananias,

I think there was some minor syntax error and the script given by Modifier is correct. Try it....

[Ananias]

I would really like to thank you guys......the problem is solved.....the script provided by Modifier worked nicely !!!!

Thanks a lot once again.......bye