Re: newbie: problem with "select in (select)"

2001-02-05 Thread René Tegel
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

newbie: problem with "select in (select)"

2001-02-05 Thread Henrik Lebtien Mohr
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