Question

mysql5里运行正常,MYSQL4失败.急...

兄弟,这个在MYSQL5里正常,在4里却提示错误,能帮忙解答一下么.感激

SELECT nickname
FROM qun_supe_userfields
WHERE uid
IN (
SELECT qun_supe_userspaces.uid
FROM supe_qun_userspaces
WHERE qun_supe_userspaces.uid = '$value[uid]'
);

提示错误:
1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'select qun_supe_userspaces.uid from
supe_qun_userspaces where
是的,不支持子查询.他们跟我说要用 LEFT JOIN来代替,但我不知道具体该怎么代替,我用LEFT JOIN代替IN,错误了.有谁知道完整的语句该怎么写么?

Answer 1

mysql4.1之前的好象没子查询