SELECT * FROM `bc_ collection`, `bc_userinfo` WHERE `uid`='30' AND `bc_uid` in (SELECT * FROM `bc_userinfo` WHERE `bc_userinfo`.uid=`bc_ collection`.bc_uid) 我改成这样还是不行
SELECT * FROM bc_userinfo WHERE uid IN(SELECT bc_uid FROM bc_ collection WHERE uid='30') 你试下看行不.
try : select b.* from bc_collection as a join bc_userinfo as b on a.uid = 30
上面错了 select b.* from bc_collection as a join bc_userinfo as b on a.uid = b.uid where a.uid = 30
select uid,bc_uid from bc_ collection,bc_userinfo where bc_ collection.uid=30 and bc_userinfo.uid=bc_ collection.bc_uid;
是不是mysql的语句格式跟sql标准有出入呀。
上面好几句都是没问题的. 如果你得不到需要的结果,最好把运行结果post上来,然后再说你需要的结果
select uid,email,province from bc_userinfo where uid in (select bc_uid from bc_collection where uid = "30")时间太紧没时间试,你试试看行不。
我改成这样还是不行
你试下看行不.
select b.* from bc_collection as a join bc_userinfo as b on a.uid = 30
select b.* from bc_collection as a join bc_userinfo as b on a.uid = b.uid where a.uid = 30
如果你得不到需要的结果,最好把运行结果post上来,然后再说你需要的结果
from bc_userinfo
where uid in (select bc_uid from bc_collection where uid = "30")时间太紧没时间试,你试试看行不。