Results 1 to 2 of 2

Thread: left join

  1. #1
    Join Date
    Dec 2005
    Kochi, Kearala, india

    Unanswered: left join

    can any one tell me whether this query is correct or not?

    select distinct patient_demog_prostat.patient_id , patient_demog_prostat.BMI from patient_demog_prostat LEFT JOIN cancer on patient_demog_prostat.patient_id=cancer.patient_id left join patient_analysis on patient_demog_prostat.patient_id = patient_analysis.patient_id where ( GA1932 >=0 and GA1932 <=10 ) and (cancer_you = 'COLON CANCER') order by patient_id asc

    where GA32 is a column of patient_analysisy table

  2. #2
    Join Date
    Apr 2005
    Baltimore, MD
    It's pretty hard to tell without knowing your table schemas, their relationships to each other, and most importantly: what results you are trying to get.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts