Re: sql compleja, para mi

Article View: es.comp.os.linux.programacion

Article #7371

Back to es.comp.os.linux.programacion Previous Next

#7371

From: Jayr Al-Dyn
Date: Mon, 03 Mar 2003 20:09

31 lines
1778 bytes

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Edu dec�a:

> select id from articulos where titulo in ( select titulo as titulo from
> propietarios where nombre=$cadena )
> 

�Y no es m�s f�cil algo como...

 select a.id
   from articulos a, propietarios p
  where p.nombre = $cadena
    and a.titulo = p.titulo

?

Vaya, digo yo... y adem�s un pel�n m�s eficiente.

- -- 
Jayr Al-Dyn
Usuario Linux #95614 en counter.li.org
http://www.jayraldyn.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.0 (GNU/Linux)

iD8DBQE+Y7Zk7KeWPNVnigARAlf0AJ9k0JDUpn/mACc/+HyCN9X2Nr9pvQCcCjxo
sptJjw3unsKBWTfAU/rcD6s=
=eama
-----END PGP SIGNATURE-----

Technical Details

Message-ID: <b40cpi$cim$1@rantanplan.linux.es>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!feed3.newsreader.com!newsreader.com!news-xfer.cox.net!mainake.escomposlinux.org!not-for-mail

References: <b3vuo0$1pv3q1$1@ID-59646.news.dfncis.de> <b40b26$1ad$1@nsnmrro2-gest.nuria.telefonica-data.net>

Show Full Headers

Complete Article Headers

X-Google-Language: SPANISH,ASCII
X-Google-Thread: f86c8,8e2a50929db49026
X-Google-Attributes: gidf86c8,public
X-Google-ArrivalTime: 2003-03-03 12:09:25 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!newsfeed.stanford.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!feed3.newsreader.com!newsreader.com!news-xfer.cox.net!mainake.escomposlinux.org!not-for-mail
From: Jayr Al-Dyn <jayraldyn@jayraldyn.net>
Newsgroups: es.comp.os.linux.programacion
Subject: Re: sql compleja, para mi
Date: Mon, 03 Mar 2003 21:09:08 +0100
Organization: MALOU
Lines: 31
Message-ID: <b40cpi$cim$1@rantanplan.linux.es>
References: <b3vuo0$1pv3q1$1@ID-59646.news.dfncis.de> <b40b26$1ad$1@nsnmrro2-gest.nuria.telefonica-data.net>
NNTP-Posting-Host: 213-98-164-133.uc.nombres.ttd.es
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8Bit
X-Trace: rantanplan.linux.es 1046722163 12886 213.98.164.133 (3 Mar 2003 20:09:23 GMT)
X-Complaints-To: usenet@mainake.escomposlinux.org
NNTP-Posting-Date: Mon, 3 Mar 2003 20:09:23 +0000 (UTC)
User-Agent: KNode/0.7.1

Reply to Parent Message