Just checkout it is working.. I hope you wi<ll use="" mode="hold">
SELECT * from mst_members s1
left join mst_members_photo od ON CAST(CAST(s1.its_ID AS DECIMAL(20)) AS VARCHAR(20)) = od.its_id
Join with 3 tables
select a.pt_id,a.pt_firstname + ' ' + a.pt_lastname as p_name, b.i_systolic, b.i_diastolic, c.i_pulse from patient_master a, nur_pressure b, nur_pulse c where a.pt_id =b.pt_id and a.pt_id =c.pt_id group by a.pt_id,a.pt_firstname + ' ' + a.pt_lastname, b.i_systolic, b.i_diastolic, c.i_pulse order by a.pt_id