MS Access 2007查询未返回任何结果

Question

我正在使用以下查询来查找来自医学科的客户：

SELECT client.clientID, client.firstname, client.lastname, client.organization,
       client.department, client.email, events.Date, events.title,
       eventAttendance.eventID, eventAttendance.clientID,
       eventAttendance.attended
FROM client INNER JOIN 
     (events INNER JOIN eventAttendance ON events.id = eventAttendance.ID) 
     ON client.clientID = eventAttendance.clientID
WHERE client.organization like '%medicine'

在该表中，可能是“医学院”和“医学系”；但是，没有返回任何记录。我遗漏了什么？

谢谢。

Answer 1

Access中的通配符是*而不是%

如下所示更改您的sql：

like '*medicine'

Answer 2

我认为你可能并不总是有一个事件，所以你需要左连接：

SELECT client.clientID, client.firstname, client.lastname, client.organization,
       client.department, client.email, events.Date, events.title,
       eventAttendance.eventID, eventAttendance.clientID,
       eventAttendance.attended
FROM client LEFT JOIN 
     (events LEFT JOIN eventAttendance ON events.id = eventAttendance.ID) 
     ON client.clientID = eventAttendance.clientID
WHERE client.organization like '*medicine'