At 15:35 -0700 8/7/04, john sayre wrote:
I'm trying to do some simple in or exists queries, but am getting
syntax error on queries that appear to be correct. If I run the
outside & sub queries alone, not problem. In the In subquery, if I
hardcode a value, ok but this fails:
SELECT * FROM erestbase WHERE erestbase.id in(SELECT distinct
idcid.id FROM idcid)
This is stupid. Nothig would be wrong here in sqlServer etc. Both
ids are integer values.
Is your version of MySQL older than 4.1?
http://dev.mysql.com/doc/mysql/en/Subqueries.html
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
