Click here to Skip to main content
11,639,765 members (60,289 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: MySQL
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'




when i am selecting values from disease_parameter and patient_progress_tracking_header
1 recorde get selected 3 times..please help me
Posted 15-Jan-13 19:05pm
ujali439

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

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'
  Permalink  
v2
Comments
ujali at 16-Jan-13 1:19am
   
SELECT b.Patient_Id, a.ParameterId,b.Id,a.Target_Value,a.Sub_Type_Code
FROM disease_parameter a inner join patient_progress_tracking_header b on a.DiseaseId = b.DiseaseId
WHERE a.DiseaseId = 1 and b.Sub_Type_Code='BIOMADE'

I tried this also..this is also giving multiple rows
josh-jw at 16-Jan-13 1:22am
   
without seeing your table result , i am not sure about this join. one thing do give a group by clause .

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Suvendu Shekhar Giri 330
1 CPallini 177
2 F-ES Sitecore 170
3 sasanka sekhar panda 155
4 jyo.net 142
0 OriginalGriff 9,081
1 Sergey Alexandrovich Kryukov 8,847
2 Mika Wendelius 7,027
3 Suvendu Shekhar Giri 2,650
4 F-ES Sitecore 2,558


Advertise | Privacy | Mobile
Web03 | 2.8.150731.1 | Last Updated 16 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100