56,679
社区成员
发帖
与我相关
我的任务
分享
create function f_test(id text)
returns decimal(18,2)
return(
SELECT
IFNULL(SUM(a.money), 0)
FROM
emep_Account a
WHERE
a.type IN (2 , 8)
AND MATCH (a.parents) AGAINST (id)
);
SELECT
u.id,
u.loginName NAME,
u.memberType type,
u.fanDian AS fan,
f_test(u.id) fanDian
FROM
emep_user u
WHERE
u.id = 80182 OR u.parentId = 80182