两张表用leftJoin时如何剔除右边为空的数据 返回

SqlSugar
2 145

请大佬帮帮忙,两张表用leftJoin时如何剔除右边为空的数据

sql :SELECT * FROM sp_permission_api as api LEFT JOIN sp_permission as main ON main.ps_id = api.ps_id WHERE main.ps_id is not null

main.ps_id is not null要怎么实现

热忱回答2