consulta mysql

Article View: chile.comp.programacion

Article #3302

Back to chile.comp.programacion Previous Next

#3302

From: Rickoj
Date: Thu, 07 Apr 2005 23:56

4 lines
1059 bytes

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: <d34hfe$e77$1@news1.nivel5.cl>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!nntp-server.pubsub.com!news1.nivel5.cl!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1593cb,9070da774c101bc6,start
X-Google-Attributes: gid1593cb,public
X-Google-Language: SPANISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!nntp-server.pubsub.com!news1.nivel5.cl!not-for-mail
From: "Rick_oj" <rick_oj@[sin-esto]tutopia.com>
Newsgroups: chile.comp.programacion
Subject:  consulta mysql
Date: Thu, 7 Apr 2005 19:56:09 -0400
Organization: Varios
Lines: 6
Message-ID: <d34hfe$e77$1@news1.nivel5.cl>
NNTP-Posting-Host: pc-97-201-120-200.cm.vtr.net
X-Trace: news1.nivel5.cl 1112918318 14567 200.120.201.97 (7 Apr 2005 23:58:38 GMT)
X-Complaints-To: news@news1.nivel5.cl
NNTP-Posting-Date: Thu, 7 Apr 2005 23:58:38 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1478
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1478