This is now syntactically correct, whether it does what you require I can only guess without DDL and expected results from you.
update
eligibilityhistory
set
terminationdate='09/30/2007'
from
eligibilityhistory
inner join benefitplans
on eligibilityhistory.benefitplanid=benefitplans.benefitplanid
inner join pcphistory
on eligibilityhistory.memberid=pcphistory.memberid
where
benefitplans.healthplanid='BCN'
and pcphistory.providerid='1532'
and terminationdate is null
I recommend you run this first to see what is going to be updated before you actually run the update above.
Select
*
from
eligibilityhistory
inner join benefitplans
on eligibilityhistory.benefitplanid=benefitplans.benefitplanid
inner join pcphistory
on eligibilityhistory.memberid=pcphistory.memberid
where
benefitplans.healthplanid='BCN'
and pcphistory.providerid='1532'
and terminationdate is null Last edited by hollystyles; Aug 30th, 2007 at 9:18 am.