Re: can't get NOT IN to work - Justin Wesbrooks - com.mysql.lists.java

9 messages in com.mysql.lists.javaRe: can't get NOT IN to work

From	Sent On	Attachments
Justin Wesbrooks	07 May 2003 07:54
Jeremy Zawodny	07 May 2003 11:13
Steve Forsyth	07 May 2003 11:14
Paul DuBois	07 May 2003 11:16
Justin Wesbrooks	07 May 2003 12:46
Jeremy Zawodny	07 May 2003 12:55
Justin Wesbrooks	07 May 2003 13:00
Justin Wesbrooks	07 May 2003 13:08
Justin Wesbrooks	07 May 2003 13:41

Subject:	Re: can't get NOT IN to work
From:	Justin Wesbrooks (wesb...@amerch.com)
Date:	05/07/2003 01:00:46 PM
List:	com.mysql.lists.java

[MyServer] ERROR 1235: This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

Jeremy Zawodny <jzawodn@yahoo-in c.com> To Justin Wesbrooks 05/07/2003 02:56 <wesb...@amerch.com> PM cc ja...@lists.mysql.com Subject Re: can't get NOT IN to work

I've got 4.1 downloaded now and it appears that it still doesn't support sub-selects with the IN / NOT IN clause.

Any ideas on how to rewrite this query to work with v 4.1?? SELECT * FROM MEMBER where ID not in (select MEMBER_ID from MEMBER_DUES where DUES_YEAR = 2003)

Let's start with the basics. What error message does the MySQL server give you?