Paul,
SELECT * from encore enc, article art
WHERE enc.encore_id= '10' AND `article_id` IN (`articles`)
First, IN() accepts either a literal value list, or a subquery which
returns a value list. Just passing it a table name won't work.
Second, your join looks suspicious. Is this what you mean?...
SELECT *
FROM encore AS enc
INNER JOIN article AS art USING (article_id)
WHERE enc.encore_id= 10;
PB
-----
Paul Nowosielski wrote:
Hello,
I'm trying to run q query with an IN statement in MySQL 5. Like so:
SELECT * from encore enc, article art
WHERE enc.encore_id= '10' AND `article_id` IN (`articles`)
Its should return all the articles in the encore.articles column but
instead only returns the first article.
In encore,articles is the data 43,44,45,46.
These are article IDs. If I manually place 43,44,45,46 into the query
like so:
SELECT * from encore enc, article art
WHERE enc.encore_id= '10' AND `article_id` IN (43,44,45,46)
All 4 articles are returned. Any ideas why this is not working?
TIA!
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.17/226 - Release Date: 1/10/2006
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
