此查询提供了一个错误.你能提供一个答案吗

Question

Select a.PatientId,a.name as PatientName,c.treatmentDescription as TreatmentName
FROM patient as a inner join patient-treatment as b
on a.patientID = b.PatientID
INNER JOIN Treatment as c
ON b.TreatmentCode = c.TreatmentCode
WHERE a.address = "Woodstock" OR "Roswell";

Answer 1

查询的这一行不正确：

WHERE a.address = "Woodstock" OR "Roswell"

应该是：

WHERE a.address = 'Woodstock' OR a.address = 'Roswell'

或者你也可以这样写：

WHERE a.address in ('Woodstock', 'Roswell')

Answer 2

我想问题出在WHERE子句上。

尝试：

a.address = 'Woodstock' OR a.address = 'Roswell'; 

或：

a.address IN ('Woodstock', 'Roswell');

示例：

Select a.PatientId,a.name as PatientName,c.treatmentDescription as TreatmentName
FROM patient as a inner join patient-treatment as b
on a.patientID = b.PatientID
INNER JOIN Treatment as c
ON b.TreatmentCode = c.TreatmentCode
WHERE a.address = 'Woodstock' OR a.address = 'Roswell';

Answer 3

用单引号替换双引号。

和where子句不正确。应采用形式

A.name="x"和A.name="y"。过滤器内部的条件本质上应该是布尔型的。

Answer 4

您的where应该如下所示：其中a.Addrrss="Woodstock"或a.Address="Roswell">