The multi-part identifier could not be bound
- by jello
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…