Many to Many

[Agustin Eloy Barrios Arteaga]

Hello again

here send al SQL to generate the database to test in MYSQL,
for example in case that I Question in the query that a Productor
TECUN (1)  no cant be return, pepe(2), lolo(1)
CEIS (2)  no cant be return lolo(1)
PCMAX (3)  no cant be return pepe(2)
A Numbres are the ID In the table cp the ID from Consumidor are IDC and
whish Productor are IDP




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Translate

[Agustin Eloy Barrios Arteaga]

I need translate this SQL to any SQL that work in MYSQL

SELECT * FROM cons WHERE NOT EXISTS (SELECT idc FROM cp  where
cons.id=cp.idc and cp.idp = 1);


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Fw: Select Diferences

[Agustin Eloy Barrios Arteaga]

- Original Message -
From: [EMAIL PROTECTED]
To: "Agustin Eloy Barrios Arteaga" [EMAIL PROTECTED]
Sent: Friday, April 13, 2001 8:22 AM
Subject: Re: Diferences


 Your message cannot be posted because it appears to be either spam or
 simply off topic to our filter. To bypass the filter you must include
 one of the following words in your message:

 database,sql,query

 If you just reply to this message, and include the entire text of it in
the
 reply, your reply will go through. However, you should
 first review the text of the message to make sure it has something to do
 with MySQL. You have written the following:


 Hello:

 I have 3 tables to obtain one relation many to many, and need know when
all
 elements whats not exists in the other part of relation.

 sorry my bad english
 **
 * Agustin Eloy Barrios Arteaga*
 * Supervisor del CEIS *
 *[EMAIL PROTECTED]*
 **
 *



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php