when TB_EX_MBR_STAFF.durable_mbr_acc_id is null then 'N' ELSE 'Y' END AS EX_MBR_STAFF
,case when TB_EX_MBR_RESEARCH_OPT_OUT.durable_mbr_acc_id1799_1m TB_EX_MBR_COMPLAINTS on a.durable_mbr_acc_id = TB_EX_MBR_C
然后,它应该将其与mbr表连接起来,以查找电话号码是否连接到mbr表中的人名。无论如何,在mbr表中,电话号码可能在“phone”或"mobilephone“列中,所以我们必须同时检查这两个列。where子句中的OR运算符使查询超过20秒,因为它不使用mbr.telephone和mbr.mobilephone的现有索引。ON mbr.telephone = sms.phonenumber left join mbr as mbr2 ON
<