Access 2013 SQL：``不喜欢''问题
技术问答
175 人阅读
|
0 人回复
|
2023-09-12
|
|
我不知道为什么我WHERE 子句似乎还在回归SPEC”的列值…我在这里做错了什么？[H姓氏是唯一一个包含这个名字/值的列。
" V; d' D3 H- A3 ?! ?( ISELECT [H1 LAST Name] & "," & [H1 FIRST Name] AS [FULL Name], [H1 E-Mail] AS [E-Mail], IIF([H1 Cell Phone] IS NULL,[Home Phone],[H1 Cell Phone]) AS PhoneFROM NameLookupWHERE ((NameLookup.[H1 LAST Name] NOT LIKE '%SPEC%') OR (NameLookup.[H1 LAST Name] NOT LIKE '%MODEL) AND (NameLookup.[H1 LAST Name] IS NOT NULL)UNION ALLSELECT [H2 LAST Name] & "," & [H2 FIRST Name] AS [FULL Name], [H2 E-Mail] AS [E-Mail], IIF([H2 Cell Phone] IS NULL,[Home Phone],[H2 Cell Phone]) AS PhoneFROM NameLookupWHERE ((NameLookup.[H1 LAST Name] NOT LIKE '%SPEC%') OR (NameLookup.[H1 LAST Name] NOT LIKE '%MODEL) AND (NameLookup.[H2 LAST Name] IS NOT NULL)ORDER BY [FULL NAME]
3 U$ s, g* I) Z" M k% i9 y 解决方案: |
|
|
|
|
|
|
|
|
|
