Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id C24C69FB550 for ; Tue, 15 May 2007 10:17:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 72023-02 for ; Tue, 15 May 2007 10:17:24 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id CC6C49FB5B0 for ; Tue, 15 May 2007 10:17:29 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id DECB730AF3; Tue, 15 May 2007 15:17:27 +0200 (MET DST) From: Paul251 X-Newsgroups: pgsql.sql Subject: SQL Query Validate Records Multiple Tables - Help Needed Date: 15 May 2007 06:17:26 -0700 Organization: http://groups.google.com Lines: 17 Message-ID: <1179235046.748509.130630@y80g2000hsf.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Complaints-To: groups-abuse@google.com User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; InfoPath.1),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: y80g2000hsf.googlegroups.com; posting-host=161.154.235.27; posting-account=WlPrWQ0AAADce3UaLq6swFJCfH39XS1Y To: pgsql-sql@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/143 X-Sequence-Number: 28423 Hello... I am trying to validate a asset number (10 Characters) from one table to another table. Problem is they are in two different DB's and haven't done that before? Basically trying to take record 1 from Table 1/DB1 and validate it against record 1 in Table 2/DB2 if the record doesn't exist in Table 2/ DB2 update the flag to N in Table 1/DB1..... Seems easy but been working on it for about a week now no luck.... :-( I have the mostly the same colums in both tables but Table 2/DB2 is the host table I need to verify from.... Does anyone have any help or code to help me do this?? Thanks