You can use JOIN...
See: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html
Gurhan
-Original Message-
From: van den Heuvel, Frank [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 21, 2002 8:47 AM
To: '[EMAIL PROTECTED]'
Subject: select in select
Hello,
I would like to do this witih
[snip]
> SELECT con.id,con.name FROM contacts con, registrar_contact reg
> WHERE NOT con.id IN
> (SELECT contactid FROM registrar_contact WHERE registrarid=1)
[/snip]
Current versions of MySQL do not support sub-selects.
HTH!
Jay
---
