FROM disease_parameter a
patient_progress_tracking_header b on a.DiseaseId = b.DiseaseId
WHERE a.DiseaseId = _disease_Id
AND b.Sub_Type_Code = _Sub_Type_Code
GROUP BY ParameterId
problem:Id column is giving same Id for all recordes...Id column is primary key..
please help me
Edited 17-Jan-13 21:56pm
Looks like _Sub_Type_Code is causing the same diseaseid to be returned by the query.
Pass another _Sub_Type_Code to get another set of disease values.
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)