I don't think Sub queries like the = and != operators as groupid will never
equal the result of a multi row subquery, but it can be IN a list of
results. Just to check, you are using 4.1+ right? I think this alteration
would work:
SELECT group_id,name,'SELECTED' FROM groups WHERE
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 05, 2003 10:00 AM
To: Chris
Subject: Re: MySQL sub-query error.
See..I changed it = only coz the IN wouldn't work. I am guessing its a MySQL
version issue. I am using a version below 4.0.
I am curious about the second version of my query you