Click here to Skip to main content
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 20:05pm
ujali435

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 OriginalGriff 5,170
1 DamithSL 4,357
2 Maciej Los 3,750
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,851


Advertise | Privacy | Mobile
Web02 | 2.8.141216.1 | Last Updated 16 Jan 2013
Copyright © CodeProject, 1999-2014
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