Your select has two tables, but you don't join them.
Can you provide the table info, and a subset of the data that should be
pulled back by this query?
David
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!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
