根据 Teradata 中的条件加入

Question

我正在尝试编写如下所示的内容：

case when table_1.account_or_client='A' then inner join on table_1.addr_id=table_2.addr_id where substr(table_2.addr_id,2,1) is not 0
else then inner join on table_1.addr_id=table_2.addr_id

但语法正确。我该怎么做？

我需要确保 table_2.addr_id 的第二个数字在连接期间不为 0，当 table_1.account_or_client='A'

Answer 1

我需要确保当table_2 table_1.account_or_client='A'转换为

FROM table_1 AS t1 
JOIN table_2 AS t2
ON t1.addr_id=t2.addr_id
AND NOT (t1.account_or_client='A' AND Substr(t2.addr_id,2,1) = '0')