问题：Id列为所有记录提供相同的ID [英] Problem:Id column is giving same Id for all recordes

问题描述

SELECT b.Patient_Id,
                    a.ParameterId,
                    b.Id,
                    a.Target_Value,
                    a.Sub_Type_Code,
                    a.Active,
                   _date,_Created_By
               FROM disease_parameter a
                   Inner JOIN
                       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

问题：Id列为所有记录提供相同的ID ... Id列是主键..

请帮帮我

problem:Id column is giving same Id for all recordes...Id column is primary key..
please help me

推荐答案

看起来_Sub_Type_Code会导致查询返回相同的病毒。

传递另一个_Sub_Type_Code以获取另一组疾病值。

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.

这篇关于问题：Id列为所有记录提供相同的ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！