lxq73061
注册会员
UID 93064
精华
0
积分 94
帖子 49
金钱 94 喜悦币
威望 0
人脉 0
阅读权限 20
注册 2007-5-15
状态 离线
|
一个有关子查询的问题
打印出来的sql：
SELECT
m.uid,m.username,m.gender,m.regdate,m.credits,m.extcredits1,m.extcredits2,m.extcredits3,m.extcredits4,m
.extcredits5,m.email,m.introducer,m.state,m.level,m.fromweb,m.underling, f.nickname, f.location,
consumption FROM cdb_members m left join cdb_memberfields f on (f.uid = m.uid) ,(SELECT sum(amount)
as consumption FROM cdb_gmember_order WHERE username = 'm.username') as consumption
请教:为什么username = 'm.username'没有作用?
原语句:
$mysql = "SELECT
m.uid,m.username,m.gender,m.regdate,m.credits,m.extcredits1,m.extcredits2,m.extcredits3,m.extcredits4,m
.extcredits5,m.email,m.introducer,m.state,m.level,m.fromweb,m.underling, f.nickname, f.location,
consumption FROM {$tablepre}members m left join {$tablepre}memberfields f on (f.uid = m.uid) ,(SELECT
sum(amount) as consumption FROM {$tablepre}gmember_order WHERE username = 'm.username') as
consumption";
|
|
