问题;多行正在选择.. [英] problem;multiple rows are selecting..

问题描述

SELECT b.Patient_Id, a.ParameterId,b.Id,a.Target_Value,b.Sub_Type_Code
            FROM disease_parameter a, patient_progress_tracking_header b
           WHERE a.DiseaseId = 1 and b.Sub_Type_Code='BIOMADE'

当我选择来自disease_parameter和patient_progress_tracking_header的值时


1记录被选中3次..请帮助我

when i am selecting values from disease_parameter and patient_progress_tracking_header
1 recorde get selected 3 times..please help me

推荐答案

check这个链接。

http://www.roseindia.net/sql /sqljoin/mysql-natural-join.shtml [ ^ ]



尝试在条件中加入您的查询。

check this link.
http://www.roseindia.net/sql/sqljoin/mysql-natural-join.shtml[^]

try to give join in your query with condition.

SELECT b.Patient_Id, a.ParameterId,b.Id,a.Target_Value,b.Sub_Type_Code
            FROM disease_parameter a JOIN  patient_progress_tracking_header b
           WHERE a.DiseaseId = 1 and b.Sub_Type_Code='BIOMADE'

这篇关于问题;多行正在选择..的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！