Simple Update

Database
Fan

Simple Update

I know this is pretty basic. Any help appreciated.

Update Employee set end_date=(Select effective_date-1 from Employee where empid=1) where empid=1

Basically I am trying to set the end date with a value effective date-1
1 REPLY
Senior Apprentice

Re: Simple Update

Update Employee set end_date=effective_date-1 where empid=1

Dieter