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.
pgsql-admin by date
|Next:||From: Joshua Drake||Date: 2008-10-10 05:53:51|
|Subject: Re: can I update multiple table at a time?|
|Previous:||From: Jagadeesh||Date: 2008-10-10 04:42:28|
|Subject: how to invoke edtor?|