--Update EMRPatientProblems
Set is_Coded=0 
From EMRPatientProblems a ,
(
Select a.Patient_id, a.Location_id, c.Location_id, c.Group_id as CGroupid, d.Group_id as DGroupid,
b.Problem_id, b.Patient_id, 
b.Problem_code, d.Problem_code ,
b.Problem_desc, d.Problem_desc,
b.Problem_name, d.Problem_name, 
b.Is_coded
from EMRPatientProblems  b 
Inner Join EMRpatientsMaster a on a.Patient_id = b.Patient_id
Left Outer Join EMRLocationMaster c on a.Location_id = c.Location_id
Left Outer Join EMRUncodedProblems d on b.Problem_code = d.Problem_code 
Where c.Group_id = d.Group_id and (b.Problem_code = d.Problem_code and b.Problem_desc = d.Problem_desc and b.Problem_name = d.Problem_name) and b.Is_coded=1
) b
Where a.Problem_id =b.Problem_id
--(b.Problem_code <> d.Problem_code or  b.Problem_desc <> d.Problem_desc or b.Problem_name <> d.Problem_name)

Update		a
Set		a.is_Coded = 0 
From		EMRPatientProblems as a
inner join	(
			Select		a.Patient_id,
					a.Location_id,
					c.Location_id,
					c.Group_id as CGroupid,
					d.Group_id as DGroupid,
					b.Problem_id,
					b.Patient_id, 
					b.Problem_code,
					d.Problem_code,
					b.Problem_desc,
					d.Problem_desc,
					b.Problem_name,
					d.Problem_name, 
					b.Is_coded
			from		EMRPatientProblems as b 
			Inner Join	EMRpatientsMaster as a on a.Patient_id = b.Patient_id
			Left Join	EMRLocationMaster as c on a.Location_id = c.Location_id
						and c.Group_id = d.Group_id
			Left Join	EMRUncodedProblems as d on b.Problem_code = d.Problem_code 
						and b.Problem_code = d.Problem_code
						and b.Problem_desc = d.Problem_desc 
						and b.Problem_name = d.Problem_name
			Where		b.Is_coded=1
		) as b on a.Problem_id =b.Problem_id