Re: [SQL] update with join

On Wed, 2 Apr 2008 23:54:18 -0300 "Osvaldo Kussama" <[EMAIL PROTECTED]> wrote: > 2008/4/2, Ivan Sergio Borgonovo <[EMAIL PROTECTED]>: > > I've > > > > create table types( > > typeid int, > > special boolean not null > > ); > > > > create table methods( > > methodid int, > > typeid refer

Re: [SQL] update with join

2008/4/2, Ivan Sergio Borgonovo <[EMAIL PROTECTED]>: > I've > > create table types( > typeid int, > special boolean not null > ); > > create table methods( > methodid int, > typeid references types(typeid), > ); > > create table orders( > orderid int > ); > > create table order_pay