joins子查询问题

[zsy619]

Your Question

有以下sql语句：

SELECT a.*,CASE WHEN b.role_id IS NULL THEN FALSE ELSE TRUE END as checked FROM sso_menu a 
LEFT JOIN (SELECT * FROM sso_role_menu WHERE role_id = 100) b on a.id = b.menu_Id
ORDER BY a.sort,a.id

使用gen如何进行构建

The document you expected this should be explained

Expected answer

[tr1v3r]

涉及 case when这种比较复杂的语法的问题，建议用DIY method实现