Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f15N92x81356 for ; Mon, 5 Feb 2001 18:09:02 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f11I02q76145 for ; Thu, 1 Feb 2001 13:00:02 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f11Hpbm32276 for pgsql-sql@postgresql.org; Thu, 1 Feb 2001 12:51:37 -0500 (EST) (envelope-from news) From: "guard" X-Newsgroups: comp.databases.postgresql.sql Subject: how to simulate UPdate ...? Date: Fri, 2 Feb 2001 02:01:45 +0800 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 14 Message-ID: <95c7n8$vgh$1@news.tht.net> X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 To: pgsql-sql@postgresql.org X-Archive-Number: 200102/62 X-Sequence-Number: 1232 I not run update.... in Pgsql please tell me other method thanks ====================================== update table1 a set na1= (select table2.na1 from table2,table1 where table1.no=table2.no and a.no=table1.no);