Your problem is that you are trying to do an 'IN' subquery in MySQL V4.0.x.
Subqueries don't become available in MySQL until V4.1.x. You'll need to
upgrade to V4.1 (or V5.0) to get that functionality.
Rhino
- Original Message -
From: "Scott Purcell" <[EMAIL PROTECTED]>
To:
Sent: Friday
Hi,
This is just what you're looking for :
select item.id, item.name
from item,item_cat_rel
where item.id =item_cat_rel.id
and item_cat_rel.cat_id = 5;
+--+--+
| id | name |
+--+--+
| 5000 | Triple Cage Hook |
+--+
Scott Purcell wrote:
I am in the docs trying to use the IN (13.1.8.3. Subqueries with ANY, IN, and
SOME).
Version: mysql Ver12.21 distrib 4.0.15 Win95/Win98(i32)
Look at http://dev.mysql.com/doc/mysql/en/subqueries.html
Subqueries aren't supported until 4.1.
--
Keith Ivey <[EMAIL PROTECTED]>
Smoke
