时间戳

首页 > 解决方案 > Excel 公式帮助获取正确的语法

sql - Excel 公式帮助获取正确的语法

问题描述

Excel 版本：2016

我在这里问了主要问题，这是该问题的扩展。

在 EXCEL 中构建 SQL SELECT 语句 在此处输入图像描述

每当 sql“AND”子句中有值时，我都需要扩展所有列的逻辑。

例如。AND TAB1.COLUMNA = TAB2.TCOLUMNA AND TAB1.COLUMNB = TAB2.COLUMNB依此类推，仅当 DIM 列中有值时。

我不确定如何使用 SUBSTITUTE 和 TRIM 函数动态嵌入它。

编辑：公式

="select * from (SELECT RET_ID,RET_NM,"&SUBSTITUTE(TRIM(C2&" "&D2&" "&E2&" "&F2)," ",",")&" FROM 
TABLEX ORDER BY "&SUBSTITUTE(TRIM(C2&" "&D2&" "&E2&" "&F2)," ",",")&") TAB1 FULL OUTER JOIN   (SELECT RET_ID,RET_NM,"&SUBSTITUTE(TRIM(C2&" "&D2&" "&E2&" "&F2)," ",",")&" FROM 
TABLEX ORDER BY "&SUBSTITUTE(TRIM(C2&" "&D2&" "&E2&" "&F2)," ",",")&") TAB2 ON TAB1.RET_ID = TAB2.RET_ID AND TAB1.RET_NM = TAB2.RET_NM  "

标签： sqlexcelexcel-formula

解决方案

解决了，通过这段代码

"&IF(LEN(D2)>0,CONCATENATE("AND COALESCE(TAB1.",D2,",'')","="," COALESCE(TAB2.",D2,",'')"),"")&"

推荐阅读