select uid,(select wechat from member_a where tuid=m.tuid)wechat,
(select name from admin_user where id =(select opuid from link where id=ldid))fzr
,no,ctime,(select ctime from member where id=uid)uctime,
ldid,adid,rmb,(select count(id) from money_o where uid=m.uid and ctime < m.ctime)readin,
(select count(id) from money_o where uid=m.uid and ctime > m.ctime)readout
from money m where
ldid in(select id from link where qd=666 and ctime>$tms) and
status=1 and ctime>=$czs having ctime> uctime and (ctime-uctime<480);
select uid,(select wechat from member_a where tuid=m.tuid)wechat, (select name from admin_user where id =(select opuid from link where id=ldid))fzr ,no,ctime,(select ctime from member where id=uid)uctime, ldid,adid,rmb,(select count(id) from money_o where uid=m.uid and ctime < m.ctime)readin, (select count(id) from money_o where uid=m.uid and ctime > m.ctime)readout from money m where
ldid in(select id from link where qd=666 and ctime>$tms) and status=1 and ctime>=$czs having ctime> uctime and (ctime-uctime<480);
在后端程序中少不了要和 sql 接触，一部分人对子查询很抗拒认为 把很多逻辑都隐藏到 sql 中了不利于程序的可读性，然而 你同意吗？
上述 sql 使用了很多子查询，查询效率也并不会低，不过肯定可以省很多代码，因为很多数据如果不用子查询，那么就要多次链接数据库去做查询，然后组合数据。
愚见：适当的使用子查询其实是会更高效的！