识别同一用户通过多个交易账号购买同一基金的情况

原创已于 2025-05-23 08:09:58 修改 · 240 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

于 2025-05-22 19:24:35 首次发布

同卡购买同产品


select a.vc_fundcode,
       a.en_totalshare,
       b.vc_bankacco,
       b.vc_tradeacco,
       b.vc_nameinbank
  from vstaticshare a, taccobank b
 where a.vc_tradeacco = b.Vc_Tradeacco
   and a.en_totalshare > 0
   and exists (select 1
          from vstaticshare c, taccobank d
         where a.vc_fundcode = c.vc_fundcode
           and c.vc_tradeacco = d.vc_tradeacco
           and c.vc_fundacco = a.vc_fundacco
           and a.c_Sharetype = c.c_Sharetype
           and b.vc_tradeacco <> d.vc_tradeacco
           and b.vc_bankacco = d.vc_bankacco
           and c.en_totalshare > 0)