如何在表B中创建新列的使用情况以显示表A中的数据是否也在表A中

发布于 2025-02-08 01:01:32 字数 1121 浏览 3 评论 0原文

当我尝试遵循代码时，它将返回所附的错误代码

select  acct_key,
       (case when acct_key in (
                                select acct_key
                                from table_A
                              ) 
       then 1 else 0 end) as acct_indicator
from  table_B;

作为单个语句执行。失败[804：08S01]数据包的套接字通信失败星期三5月25日12:01:18 CDT 2022插座artir = vtdsssbp.rw.discoverfinancial.com local =/10.2.181.125：61593 170.217.201.43:1025 keepalive = false nodelay = false = false = 65536发送= 65536发送= 64512 linger = 10流量= 10交通= 0同时= 3 contimeT = 3 contimeout = 10000 conwait = 1000 connwaittime = 1000 connecttime = 38 ConnectTotAltime = 38 ConnectAttAltime = 38 ConnectAttEmpts = 1 ConnectFailures = 1 ConnectFailures = 0 ConnectFaiLures = 0 connectfailsempts = 0 connectnects = 0 redrive = false failurecache = {} cid = 1221D607 sess = 106395528 java.net.socketException：软件引起的连接abort：java.net.sockett.socketOutputputputSocketStstream.socketstream.socketstream.socketStstream.socketstream.socketstream.socketstream.socketSocketSocketSocketSocketSocketSockeDemand（net））at Java.net.SocketOutputstream.write（未知来源）...

原文

When I try following code it returns attached error code

select  acct_key,
       (case when acct_key in (
                                select acct_key
                                from table_A
                              ) 
       then 1 else 0 end) as acct_indicator
from  table_B;

Executed as Single statement. Failed [804 : 08S01] Socket communication failure for Packet transmit Wed May 25 12:01:18 CDT 2022 socket orig=VTDSSBP.rw.discoverfinancial.com local=/10.2.181.125:61593 remote=VTDSSBPcop2.rw.discoverfinancial.com/170.217.201.43:1025 keepalive=false nodelay=false receive=65536 send=64512 linger=10 traffic=0 concurrent=3 contimeout=10000 conwait=1000 connecttime=38 connecttotaltime=38 connectattempts=1 connectfailures=0 reconnectattempts=0 recoverable=false redrive=false failurecache={} cid=1221d607 sess=106395528 java.net.SocketException: Software caused connection abort: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(Unknown Source) at java.net.SocketOutputStream.write(Unknown Source) at ...

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

橪书 2025-02-15 01:01:32

尝试1：

select  a.acct_key,
       case when exists (
                            select acct_key
                            from table b
                            where a.acct_key = b.acct_key
                        ) 
       then 1 
       else 0
       end as acct_indicator
from  table a;

失败
它返回案例表达条款的非法表达

尝试2：

select a.acct_key,
       case when b.acct_key is not null
       then 'yes'
       else 'no'
       end as acct_ind
from table a
left join table b 
on a.acct_key = b.acct_key;

成功

attempt 1:

select  a.acct_key,
       case when exists (
                            select acct_key
                            from table b
                            where a.acct_key = b.acct_key
                        ) 
       then 1 
       else 0
       end as acct_indicator
from  table a;

failed as
it returns Illegal expression in When Clause of case expression

attempt 2:

select a.acct_key,
       case when b.acct_key is not null
       then 'yes'
       else 'no'
       end as acct_ind
from table a
left join table b 
on a.acct_key = b.acct_key;

succeed

回复收藏 0 原文

~没有更多了~