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

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.