Open
Description
版本信息(Version)
v4.25.02
问题描述(Describe)
期望以下sql不会触发规则00079,其中虽然有别名重复,但是是针对相同的表和列,不应该触发规则
SELECT DISTINCT t_mem.first_name AS mem_first_name, t_mem.last_name AS mem_last_name, t_mem.phone AS mem_phone FROM expense AS t_exp INNER JOIN budget AS t_bud ON t_exp.link_to_budget = t_bud.budget_id INNER JOIN member AS t_mem ON t_mem.member_id = t_exp.link_to_member WHERE t_exp.cost > ( SELECT AVG(t_exp.cost) FROM expense AS t_exp INNER JOIN budget AS t_bud ON t_exp.link_to_budget = t_bud.budget_id INNER JOIN member AS t_mem ON t_mem.member_id = t_exp.link_to_member );