The multi-part identifier could not be bound

Posted by jello on Stack Overflow See other posts from Stack Overflow or by jello
Published on 2010-03-28T04:47:10Z Indexed on 2010/03/28 4:53 UTC
Read the original article Hit count: 439

Filed under:
|
|
|

I have this very simple sql statement:

SELECT     max_dose
FROM         psychotropes
WHERE     (patient_meds.psychotrope = psychotrope_name) AND (patient_meds.patient_id = 12)

when I try to run it in Visual Studio 2008, it tells me "The multi-part 'patient_meds.psychotrope' identifier could not be bound"

it's weird, because I did set a relationship between the two tables in the diagram viewer

© Stack Overflow or respective owner

Related posts about sql

Related posts about identifier