Many to Many

2001-04-19 Thread 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

Translate

2001-04-19 Thread 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

Fw: Select Diferences

2001-04-13 Thread 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