From: Rajesh Kumar Mallah <mallah@trade-india.com>
Organization: Infocom Network Limited
To: pgsql-sql@postgresql.org
Subject: getting rid of "Adding missing FROM-clause entry...."
Date: Thu, 17 Apr 2003 15:57:47 +0530
User-Agent: KMail/1.5
MIME-Version: 1.0
Content-Type: text/plain;
  charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200304171557.47319.mallah@trade-india.com>


Hi I am having problem with an UPDATE ... FROM
SQL where the FROM table is a subquery.

UPDATE  profile_master set title1=a.title1  FROM 
(

SELECT company_id , titile as title1 ,fname as fname1 ,mname as mname1 ,lname as 
lname1 ,company_position as desg1  from public.catalog_key_contacts  where  
company_id=profile_master.company_id order by contact_id limit 1 offset 0
)  as a 
where profile_master.source='CATALOG' ;
NOTICE:  Adding missing FROM-clause entry in subquery for table "profile_master"
UPDATE 711

its showing an update of 711 however all the 711 matching rows are getting 
updated to the same value.

can anyone tell me how to write this query properly ?

Regds
Mallah.


-- 
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.