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
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
= auteur.IDAuteur
and livre.IDLivre = livreEcritPar.IDLivre;
++-+--+
| title | Prenom | Nom |
+--------+-----+--+
| howto: MySQL | Matthew | Gold |
| howto: PHP | Matthew | Gold |
| History of Tayport | Matthew | Gold |
+---
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
- 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
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
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
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
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,
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
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
11 matches
Mail list logo