Delete Statement 1

[saw15]

I need to delete the contents of the following select statement.. but get a syntax error.

Modified a few things, but still having issues. Wondering what the correct way to write this:

select * from employer_plan
left join stage_employer_plan on employer_plan.sub_group_id = stage_employer_plan.plan_rider_code
where stage_employer_plan.plan_rider_code is null
and employer_plan.employer_plan_key not in (select employer_plan_key from member_history)

 

[JamesLean]

You can only delete from one table at a time. To delete from the employer_plan table try this:

DELETE employer_plan
FROM employer_plan left join stage_employer_plan on employer_plan.sub_group_id = stage_employer_plan.plan_rider_code
where stage_employer_plan.plan_rider_code is null
and employer_plan.employer_plan_key not in (select employer_plan_key from member_history)

--James

 

[saw15]

Thanks ... just what I needed.