Dear Code Masters,
I believe all you you are doing fine and in good health.
i want to insert some record from table "REGIMEN" to table "Common_HIVQ" and i use the statement below :
- INSERT INTO Common_HIVQ (PatientIdentifier,VisitID,VisitDate,code14,codedesctxt15)
- SELECT patientIdentifier,visitid32,visitdate33,code34,codedesctxt35 FROM Regimen WHERE VisitDate33 <> Common_HIVQ.VisitDate
but i get the following error "
Msg 4104, Level 16, State 1, Line 3
The multi-part identifier "Common_HIVQ.VisitDate" could not be bound.
"
please i have done every thing to correct this error but to no result. Kindly help me