首页select id,user_id as '用户id',app_name as '投保人', app_no as '证件号', app_phone as '手机号',order_code as '业务订单号', policy_no as '保单号', start_date as '保险生效日期',end_date as '保险结束日期',policy_state as '保险状态',agrt_name as '项目名称',biz_code as '投保渠道编号',create_time as '投保时间',case insurance_type when '0' then '亚太' when '1' then '泰康' end as '投保公司' from du_stomach_equity_user_info a where a.app_name not exists (select equity_user_name from du_stomach_user_rights_info);

select id,user_id as '用户id',app_name as '投保人', app_no as '证件号', app_phone as '手机号',order_code as '业务订单号', policy_no as '保单号', start_date as '保险生效日期',end_date as '保险结束日期',policy_state as '保险状态',agrt_name as '项目名称',biz_code as '投保渠道编号',create_time as '投保时间',case insurance_type when '0' then '亚太' when '1' then '泰康' end as '投保公司' from du_stomach_equity_user_info a where a.app_name not exists (select equity_user_name from du_stomach_user_rights_info);

时间: 2023-04-02 16:02:00 浏览: 145

这是一个 SQL 查询语句，用于查询 du_stomach_equity_user_info 表中的用户信息，包括用户id、投保人、证件号、手机号、业务订单号、保单号、保险生效日期、保险结束日期、保险状态、项目名称、投保渠道编号、投保时间和投保公司。其中，投保人不在 du_stomach_user_rights_info 表中的用户信息将被查询出来。作为一个 AI 语言模型，我可以回答这个问题。

阅读全文