你的语句拷贝下，给你写下，全部自己敲太麻烦了

${if(SQL("你的数据库定义链接名","select count(*) from base_project_t p inner join sys_organization_t t on p.org_id=t.org_id where t.parent_org_id='13265163' and t.org_id=(select org_id from sys_user_data_right_v where user_id='"+userId+"') order by t.org_id",1,1)>0,"select p.project_id,p.project_name,t.org_id,t.org_name from base_project_t p inner join sys_organization_t t on p.org_id=t.org_id where t.parent_org_id='13265163' and t.org_id=(select org_id from sys_user_data_right_v where user_id='"+userId+"') order by t.org_id","select p.project_id,p.project_name,t.org_id,t.org_name from base_project_t p inner join sys_organization_t t on p.org_id=t.org_id where t.parent_org_id='13265163' order by t.org_id")}

----------------------------------------------------------------------------------

ID为1，有数据，第一个sql语句

ID为17777，没有数据，第二个sql语句

union all 就可以 给后边的sql加一个不等于条件 不会同时满足

  select p.project_id, p.project_name, t.org_id, t.org_name

   from base_project_t p

  inner join sys_organization_t t

     on p.org_id = t.org_id

  where t.parent_org_id = '132'

  and t.org_id=(select org_id from sys_user_data_right_v where user_id='${userId}')

 union all

 select p.project_id, p.project_name, t.org_id, t.org_name

   from base_project_t p

  inner join sys_organization_t t

     on p.org_id = t.org_id

  where t.parent_org_id = '132'

  and t.org_id<>(select org_id from sys_user_data_right_v where user_id='${userId}')

  order by 3