sql - Teradata View 的字段名称中有空格，我无法更改...如何编写带有 where 子句的 select 语句

Question

查看定义

DBName.ViewName AS LOCKING ROW FOR ACCESS 
SEL
MATL_ID                        ,
CD "Company Code"
FROM DBName.TableName;

请注意，我无法更改 View - 我只能查询...

以下作品...

select matl_id, "Company Code"
from DBName.ViewName; 

但这并不

select matl_id, "Company Code"
from DBName.ViewName
where "Company Code" in ("Abc", "Xyz"); 

对最后一句话的任何帮助表示赞赏

Answer 1

将 in ("Abc", "Xyz") 替换为 in ('Abc', 'Xyz')

" 用于对象限定。
' 用于字符串