From: | "Norman Khine" <norman(at)khine(dot)net> |
---|---|
To: | "Pgsql-Novice" <pgsql-novice(at)postgresql(dot)org> |
Subject: | What is wrong with this SQL |
Date: | 2002-08-14 19:56:38 |
Message-ID: | EIEOIOLCDOLMCNPHEGDOKEGCDKAA.norman@khine.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello,
I am a bit stuck on this UPDATE query
UPDATE (price RIGHT JOIN product ON price.product = product.id) RIGHT JOIN
supplier ON product.supplier = supplier.id SET price.price = 200
WHERE (((supplier.id)=4) AND ((supplier.status)=1) AND
((product.status)=1) AND ((price.type)=1) AND ((product.id)=100902));
This works.... but the above query gets a exception error "("
SELECT supplier.id, price.price, product.id FROM (price RIGHT JOIN
product ON price.product = product.id) RIGHT JOIN supplier ON
product.supplier = supplier.id WHERE (((su
pplier.id)=4) AND ((supplier.status)=1) AND ((product.status)=1) AND
((price.type)=1) AND ((product.id)=100902));
Thanks
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
zz/********/z/****\zzz|****\*\zz|*******|z
z/^^^^^^^^/z/******\zz|*^^^^|*|z|*|^^^^^|z norman khine
zzzzzz/**/z|**/^^\**|z|*|zzz|*|z|*|zzzzzzz mailto:norman(at)khine(dot)net
zzzzz/**/zz|*|zzzz|*|z|****/*/zz|*****|zzz purley
z/******/zz|*|zzzz|*|z|*|^^zzzzz|*|^^^|zzz UK
zzZ/**/zzzz|**\^^/**|z|*|zzzzzzz|*|zzzzzzz
zz/******/zz\******/zz|*|zzzzzzz|*|*****|z
z/^^^^^^/zzzz\^^^^/zzz|^|zzzzzzz|^^^^^^^|z
zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
From | Date | Subject | |
---|---|---|---|
Next Message | David Robertson | 2002-08-14 20:04:22 | Re: I need to know password for postgres |
Previous Message | paul butler | 2002-08-14 18:03:46 | Re: disappearing tables |