Re: What is wrong with this SQL
От | Patrick Hatcher |
---|---|
Тема | Re: What is wrong with this SQL |
Дата | |
Msg-id | OFAC9EAF00.5D396342-ON88256C15.006F01C3-88256C15.006F0E6B@fds.com обсуждение исходный текст |
Ответ на | What is wrong with this SQL ("Norman Khine" <norman@khine.net>) |
Список | pgsql-novice |
It appears you aren't updating any fields (or I'm looking at it wrong): UPDATE SOME_TABLE SET FIELD1 = SOME_VALUE From (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)); Patrick Hatcher |--------+---------------------------------> | | "Norman Khine" | | | <norman@khine.net> | | | Sent by: | | | pgsql-novice-owner@post| | | gresql.org | | | | | | | | | 08/14/2002 12:56 PM | |--------+---------------------------------> >----------------------------------------------------------------------------------------------------------| | | | To: "Pgsql-Novice" <pgsql-novice@postgresql.org> | | cc: | | Subject: [NOVICE] What is wrong with this SQL | >----------------------------------------------------------------------------------------------------------| 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@khine.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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
В списке pgsql-novice по дате отправления: