Hi, Jagadeesh
I would suggest you 2 solutions:
1. to use a function to edit these fields. That way you will be sure
that you will not forget to update both tables.
2. use a trigger on master table. If I understand you - the history
table could be filled using trigger, when data in master table changes.
That way you could change only master table in your application.
Good luck!
Jagadeesh rašė:
> Hello Gurus,
>
> Is it possible to update two table using single sql statement? huh?
> let me be clear
>
> I have table master with state and date field. And in history table I
> have same fields i.e., state and date. I'm writing an update statement
> to set 'open' state records to 'closed' state after 7. both table can
> be joined using id.
>
> Any thoughts?
>
> Thanks
>
>
--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050