SQL command

[DALIAB]

Hi,

I'm getting the following message:
SQL command not properly ended

Private Const SQL_COMMAND As String = "SELECT T.DIAG_ID, T.DIAG_FULL_DESC, D.DIAG_ID, D.DIAG_FULL_DESC, W.DOCTOR_WORDING FROM DIAGNOSIS_BRIDGE B, DIAGNOSIS_ICD10 T, DOCTOR_WORDING W, DIAGNOSIS D WHERE T.DIAG_ID = B.DIAG_ICD10_ID AND B.DIAG_ID = D.DIAG_ID AND D.DIAG_ID = W.DIAG_ID"

The relationship: DIAGNOSIS_bridge diagnosis_ICD10 is a 1 to many realtionship and diagnosis doctor_wording the same.

Thanks,

Dalia

[jovery]

Not sure how your executing this command, but I think you need to terminate the statement with a ;

eg

Private Const SQL_COMMAND As String = "SELECT T.DIAG_ID, T.DIAG_FULL_DESC, D.DIAG_ID, D.DIAG_FULL_DESC, W.DOCTOR_WORDING FROM DIAGNOSIS_BRIDGE B, DIAGNOSIS_ICD10 T, DOCTOR_WORDING W, DIAGNOSIS D WHERE T.DIAG_ID = B.DIAG_ICD10_ID AND B.DIAG_ID = D.DIAG_ID AND D.DIAG_ID = W.DIAG_ID;"

Regards