Click here to Skip to main content
12,955,372 members (60,130 online)
Rate this:
 
Please Sign up or sign in to vote.
See more:
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
ujali464

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 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 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
Top Experts
Last 24hrsThis month
OriginalGriff 6,559
CHill60 3,550
Maciej Los 3,153
ppolymorphe 2,030
Jochen Arndt 1,975


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