Re: consulta mysql

Article View: chile.comp.programacion

Article #3303

Back to chile.comp.programacion Previous Next

#3303

From: Nano
Date: Fri, 08 Apr 2005 05:38

18 lines
1438 bytes

select * from clientes where rut_cliente not in (select rut_cliente from 
ventas)

Eso deber�a funcionar.

-- 
Que hago con estos weo.... ?
support@starline.ee
info@starline.ee
ponawarev@starline.ee
"Rick_oj" <rick_oj@[sin-esto]tutopia.com> escribi� en el mensaje 
news:d34hfe$e77$1@news1.nivel5.cl...
> tengo la siguiente situacion (parecida)
> una tabla con compras por clientes para dicho articulo
> como puedo seleccionar que clientes no compro el articulo x,
> existe un where not? (toy medio oxidado con bdd)
>
>

Technical Details

Message-ID: <d34r0d$h68$1@news1.nivel5.cl>

Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!news.kjsl.com!news1.nivel5.cl!not-for-mail

References: <d34hfe$e77$1@news1.nivel5.cl>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1593cb,9070da774c101bc6
X-Google-Attributes: gid1593cb,public
X-Google-Language: SPANISH,ASCII
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!news.kjsl.com!news1.nivel5.cl!not-for-mail
From: "Nano" <info@starline.ee>
Newsgroups: chile.comp.programacion
Subject: Re:  consulta mysql
Date: Thu, 7 Apr 2005 22:38:19 -0700
Organization: Varios
Lines: 20
Message-ID: <d34r0d$h68$1@news1.nivel5.cl>
References: <d34hfe$e77$1@news1.nivel5.cl>
NNTP-Posting-Host: pc-63-123-86-200.cm.vtr.net
X-Trace: news1.nivel5.cl 1112928077 17608 200.86.123.63 (8 Apr 2005 02:41:17 GMT)
X-Complaints-To: news@news1.nivel5.cl
NNTP-Posting-Date: Fri, 8 Apr 2005 02:41:17 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180

Reply to Parent Message