๐Ÿš€ go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: chile.comp.programacion
Article #1401

Re: URGENTE...UPDATE ..Informix

#1401
From: Mauricio Gomez
Date: Sat, 23 Sep 2006 03:29
21 lines
1494 bytes
En informix deberia servirte algo de la forma

UPDATE t SET a = t2.a FROM t, t2 WHERE t.b = t2.b


http://publib.boulder.ibm.com/infocenter/idshelp/v10/topic/com.ibm.sqlt.doc/sqltmst150.htm#sii061019875


rro


Tiopelao escribi๏ฟฝ:
> Holas...
> Tengo 2 tablas (A y B)y quiero actualizar los campos A2 y A3 con los 
> respectivos B2 y B3, enlazados por una clave comun A1 y B1.
> 
> Como puedo hacer esto directamente en INFORMIX.
> 
> Eso ...gracias y salu2 a to2
> TioPelao
> 
Technical Details
Message-ID: <ef29mu$cpf$1@news.nivel5.cl>
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news.glorb.com!nntp-server.pubsub.com!news.nivel5.cl!not-for-mail
References: <1491b6a42c4a2d8b9447b9886753fa31$1@usenet.no-ip.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 1593cb,538014ad71aa1e1f
X-Google-Attributes: gid1593cb,public
X-Google-Language: SPANISH,ASCII
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!news.glorb.com!nntp-server.pubsub.com!news.nivel5.cl!not-for-mail
From: Mauricio Gomez <pregunte@sileinteresa.com>
Newsgroups: chile.comp.programacion
Subject: Re: URGENTE...UPDATE ..Informix
Date: Fri, 22 Sep 2006 23:29:34 -0400
Organization: Varios
Lines: 21
Message-ID: <ef29mu$cpf$1@news.nivel5.cl>
References: <1491b6a42c4a2d8b9447b9886753fa31$1@usenet.no-ip.com>
NNTP-Posting-Host: pc-13-117-104-200.cm.vtr.net
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: news.nivel5.cl 1158982174 13103 200.104.117.13 (23 Sep 2006 03:29:34 GMT)
X-Complaints-To: news@news.nivel5.cl
NNTP-Posting-Date: Sat, 23 Sep 2006 03:29:34 +0000 (UTC)
User-Agent: Thunderbird 1.5.0.5 (X11/20060728)
In-Reply-To: <1491b6a42c4a2d8b9447b9886753fa31$1@usenet.no-ip.com>