本質上，我希望 MS Access 查詢輸出滿足以下所有三個條件的所有記錄：
- Expanded_Status = "符合條件但未注冊"
- 醫院 = "UHN"
- 評論 =“移植”或“tx”或“移植后”
注釋欄位有 3 個不同版本的“移植”一詞，因此某些欄位可能有“tx”而不是“移植”，而某些記錄可能有“移植后”而不是“移植”。
由于某種原因，下面的查詢輸出的記錄與所有三個條件都不匹配。
請幫我修改查詢，以便我只能找到滿足所有三個條件的記錄
SELECT [First Name], [Last Name], [Subject ID], Expanded_Status, Hospital, Comments
FROM [Barriers UHN Screen - 2017 Mailing]
WHERE Expanded_Status = "Eligible but not enrolled" AND Hospital = "UHN" AND Comments LIKE "transplant" OR Comments OR "post transplant" OR Comments = "tx";
uj5u.com熱心網友回復：
基于@Harun24HR 的回答：
SELECT
[First Name], [Last Name], [Subject ID], Expanded_Status, Hospital, Comments
FROM
[Barriers UHN Screen - 2017 Mailing]
WHERE
Expanded_Status = "Eligible but not enrolled" AND Hospital = "UHN" AND
(LOWER(Comments) LIKE "*transplant*" OR LOWER(Comments) LIKE "*post transplant*" OR LOWER(Comments) LIKE "*tx*");
我補充了兩點：
- 呼叫降低
Comments確保您只比較小寫字串 - 如果有人在評論中有“移植后”，它可能與“移植后”不匹配 *比較字串開頭和結尾的通配符- 這告訴 Access 我的比較字串可以在注釋中的任何位置。
喜歡運算子
uj5u.com熱心網友回復：
祖瓦，試試這個
SELECT
[First Name], [Last Name], [Subject ID], Expanded_Status, Hospital, Comments
FROM
[Barriers UHN Screen - 2017 Mailing]
WHERE
Expanded_Status = "Eligible but not enrolled" AND Hospital = "UHN" AND
(Comments = "transplant" OR Comments = "post transplant" OR Comments = "tx");
將 where 子句的 Comment 部分括在括號中，告訴 access 將每個單獨評估為 AND 子句的一部分。
轉載請註明出處，本文鏈接：https://www.uj5u.com/qianduan/326518.html