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 ma

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 th

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