|
最佳回答 |
|
0
|
CD20160914Lv8专家互助发布于2022-10-13 20:02（编辑于 2022-10-13 20:04）
|
SELECT 客户 FROM dbo.设备关键指标达成情况跟踪表 A left join 现场对应负责人 B on A.现场 = B.现场 WHERE 1=1 ${IF(or(fine_username="yukp",fine_username="gudm",fine_username="zhanggs"),"","and 账号 ='"+fine_username+"'")} |
|
|
|
|
最佳回答 |
|
0
|
weibwLv7高级互助发布于2022-10-13 20:03
|
SELECT 客户 FROM dbo.设备关键指标达成情况跟踪表 A left join 现场对应负责人 B on A.现场 = B.现场 WHERE 1=1 ${IF(or(fine_username="yukp",fine_username="yukp2",fine_username="yukp3"),"","and 账号 = '"+fine_username+"'")} |
|
|
|
|
最佳回答 |
|
0
|
hu151254Lv4见习互助发布于2022-10-13 20:06
|
WHERE 1=1 ${IF(or(fine_username='yukp',fine_username='gudm',fine_username='zhanggs'),"","and 账号 = '"+fine_username+"'")} |
|
|
|
|
最佳回答 |
|
0
|
用户k6280494Lv6资深互助发布于2022-10-14 08:50
|
SELECT 客户 FROM dbo.设备关键指标达成情况跟踪表 A left join 现场对应负责人 B on A.现场 = B.现场 WHERE 1=1 ${IF(or(fine_username='yukp',fine_username='gudm',fine_username='zhanggs'),""," and 账号 = '"+ fine_username+"'")} |
|
|
|
|
1min目标场景问卷
立即参与
