Sel ect ID,姓名1 as 姓名,电话1 As 电话 From {客户表} where 电话1 is not null Union All Sele ct ID,姓名2 as 姓名,电话2 As 电话 From {客户表} where 电话2 is not null Union All Sele ct ID,姓名3 as 姓名,电话3 As 电话 From {客户表} where 电话3 is not null Union All Sel ect ID,姓名4 as 姓名,电话4 As 电话 From {客户表} where 电话4 is not null Union All Sel ect ID,姓名5 as 姓名,电话5 As 电话 From {客户表} where 电话5 is not null
[此贴子已经被作者于2023/2/2 20:57:23编辑过]