I have read through quite a bit of the MySQL manual concerning subqueries and
cannot
seem to get even the simplist of queries to work!
I have a table called PersonRole which is the many-to-many joint table between
two
upper tables, Person and Role. I have tested the two pieces of the query
Make sure the subquery returns a scalar value. Either
the roleDBNum column has to be unique or you need to
apply an aggregate function to reduce to a single
value. If the the subquery returns many values, use
the IN operator instead of =.
Disclaimier: I'm still new to MySQL, but I'm assuming
it
Hi Renee,
Check the version of your MySQL. The subqueries feature is available from
MySQL 4.1
Hope this helps you.
- Harish
-Original Message-
From: Renee Henderson [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 23, 2004 6:17 AM
To: mysql@lists.mysql.com
Subject: simple subquery