Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: update on join ?
- From: chester c young <chestercyoung(at)yahoo(dot)com>
- To: Andreas <maps(dot)on(at)gmx(dot)net>
- Cc: sql pgsql <pgsql-sql(at)postgresql(dot)org>
- Subject: Re: update on join ?
- Date: Wed, 21 Nov 2007 19:41:54 -0800 (PST)
> I tried
>
> UPDATE things JOIN inventory ON things.thing_id = inventory.thing_fk
> SET number = 0
> WHERE color = 'red'
>
use the cool "from" clause in the update
update things t
set number = 0
from inventory i
where t.thing_id = i.thing_fk
and i.color = 'red';
____________________________________________________________________________________
Get easy, one-click access to your favorites.
Make Yahoo! your homepage.
http://www.yahoo.com/r/hs
- References:
- update on join ?
- From: Andreas
- update on join ?
- Prev by Date: Re: update on join ?
- Next by Date: Bad Schema Design or Useful Trick?
- Previous by thread: Re: update on join ?
- Next by thread: Bad Schema Design or Useful Trick?
- Indexes: