Re: Nested SELECT statements problem

2003-08-03 Thread Adam Fortuno
What version of MySQL are you using? Regards, A$ On Saturday, August 2, 2003, at 11:45 PM, Pascal Délisle wrote: Hi! I try to figure out how to use a nested "SELECT" statement after the "IN" predicate. For example, when I try this code, it doesn't return anything although it should: SELECT b

Re: Nested SELECT statements problem

2003-08-03 Thread Dan Nelson
In the last episode (Aug 03), Pascal Dlisle said: > Finally, I solved my problem by creating a temporary table that holds > the result of the subquery. So, it looks like this: ... > The only problem I see is when there are concurrent access to the > table "livreTemp", e.g. when there are multiple

Re: Nested SELECT statements problem

2003-08-03 Thread Matthew McNicol
= auteur.IDAuteur and livre.IDLivre = livreEcritPar.IDLivre; ++-+--+ | title | Prenom | Nom | +--------+-----+--+ | howto: MySQL | Matthew | Gold | | howto: PHP | Matthew | Gold | | History of Tayport | Matthew | Gold | +---

Re: Nested SELECT statements problem

2003-08-03 Thread Pascal Délisle
ay, August 03, 2003 1:02 PM Subject: Re: Nested SELECT statements problem Finally, I solved my problem by creating a temporary table that holds the result of the subquery. So, it looks like this: CREATE TABLE livreTemp (IDLivre int(11)); INSERT INTO livreTemp (IDLivre) SELECT book.IDLivre FROM li

Re: Nested SELECT statements problem

2003-08-03 Thread Jim McAtee
- Original Message - From: "Pascal Délisle" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, August 03, 2003 1:02 PM Subject: Re: Nested SELECT statements problem > Finally, I solved my problem by creating a temporary table that holds > the result of

Re: Nested SELECT statements problem

2003-08-03 Thread Pascal Délisle
matched; or otherwise the query will not return anything. Hope this helps. Lin -Original Message- From: Pascal Délisle [mailto:[EMAIL PROTECTED] Sent: Saturday, August 02, 2003 11:46 PM To: [EMAIL PROTECTED] Subject: Nested SELECT statements problem Hi! I try t

Re: Nested SELECT statements problem

2003-08-03 Thread Pascal Délisle
be matched; or otherwise the query will not return anything. Hope this helps. Lin -Original Message- From: Pascal Délisle [mailto:[EMAIL PROTECTED] Sent: Saturday, August 02, 2003 11:46 PM To: [EMAIL PROTECTED] Subject: Nested SELECT statements problem Hi! I tr

RE: Nested SELECT statements problem

2003-08-02 Thread Lin Yu
ery indeed returns some records to be matched; or otherwise the query will not return anything. Hope this helps. Lin -Original Message- From: Pascal Délisle [mailto:[EMAIL PROTECTED] Sent: Saturday, August 02, 2003 11:46 PM To: [EMAIL PROTECTED] Subject: Nested SELECT

Re: Nested SELECT statements problem

2003-08-02 Thread Eternal Designs, Inc
Dan Nelson wrote: In the last episode (Aug 02), Pascal Dlisle said: I try to figure out how to use a nested "SELECT" statement after the "IN" predicate. For example, when I try this code, it doesn't return anything although it should: SELECT book.IDLivre, aut.Prenom, aut.Nom FROM livre book,

Re: Nested SELECT statements problem

2003-08-02 Thread Dan Nelson
In the last episode (Aug 02), Pascal Dlisle said: > I try to figure out how to use a nested "SELECT" statement after the > "IN" predicate. For example, when I try this code, it doesn't return > anything although it should: > > SELECT book.IDLivre, aut.Prenom, aut.Nom FROM livre book, > livreEcrit

Nested SELECT statements problem

2003-08-02 Thread Pascal Délisle
Hi! I try to figure out how to use a nested "SELECT" statement after the "IN" predicate. For example, when I try this code, it doesn't return anything although it should: SELECT book.IDLivre, aut.Prenom, aut.Nom FROM livre book, livreEcritPar ecr, auteur aut WHERE ecr.IDLivre = book.IDLivre A