go to www.codecity.com
mysql just does not support in :(((
it's good, but far for 'sql compliant'...
gl
rene
----- Original Message -----
From: "Henrik Lebtien Mohr" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Monday, February 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 integer defining which group_id we want info on (mediumint(9))
> user_id in tblUser and tblUserLink is also defined as mediumint(9).
>
> tblUserLink is used to connect tblUser with tblGroup in a many-to-many
> relationship.
>
> Why doesn't it work? Please help.
>
> Thanks in advance, and kind regards,
> /Henrik Mohr - Denmark
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
