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
[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
---
> Hello,
>
> I would like to do this witihn mysql:
>
> SELECT con.id,con.name FROM contacts con, registrar_contact reg
> WHERE NOT con.id IN
> (SELECT contactid FROM registrar_contact WHERE registrarid=1)
>
> can someone tell me how to do this ?
>
> contacts table consists of:
> id(primary key
Hello,
I would like to do this witihn mysql:
SELECT con.id,con.name FROM contacts con, registrar_contact reg
WHERE NOT con.id IN
(SELECT contactid FROM registrar_contact WHERE registrarid=1)
can someone tell me how to do this ?
contacts table consists of:
id(primary key)
name
registrar_contac
Hello,
Please,
I use MySql, I would use INTERSECT/UNION functions and
they don't work, I need help,
My query is :
select E.*, ME.Emplacement, E.Url,E.EMail, C.Name From
Entreprise E, Mot_Entreprise ME, Mot M, Categorie C
where
(E.ID=ME.ID) and (ME.CodeMot=M.CodeMot) and (M.Mot
like 'word1%') and
05, 2001 7:46 PM
Subject: newbie: problem with "select in (select)"
> Hi again
>
> If I try the following on my MySQL DB, I get an error:
>
> select user_id from tblUser where user_id in (select user_id from
> tblUserLink where group_id = xx)
>
> xx is an intege
Hi again
If I try the following on my MySQL DB, I get an error:
select user_id from tblUser where user_id in (select user_id from
tblUserLink where group_id = xx)
xx is an integer defining which group_id we want info on (mediumint(9))
user_id in tblUser and tblUserLink is also defined as medium
