Merit Amritsar City Pselect rm.name, rm.mob, rm.dob, rm.gender, rm.district, rm.rural_urban, rm.city_name, rm.tehsil, rm.priority, tt.original_marks, tt.post_name , tt.mobile from pharma_clinic_cityadd rm INNER JOIN final_marks_pharma tt Where rm.mob = tt.mobile ORDER BY tt.original_marks DESC