SQL查询中带有" ' "的查询
在Northwind的查询中有这么一个题，查询出供货商Exotic Liquids和Mayumi's供货的产品，要求嵌套查询，可是Mayumi's的名称中有" ' " 我写的语句如下
SELECT Products.*
FROM Products,Suppliers
WHERE Products.SupplierID IN
(SELECT SupplierID
FROM Suppliers
WHERE CompanyName='Exotic Liquids'OR CompanyName='Mayumi's'
)
请问加下划线的部分要如何写？
新手提问，请不吝赐教。 SQL select
[解决办法]
SELECT *
FROM Products
WHERE SupplierID IN
(SELECT SupplierID
FROM Suppliers
WHERE CompanyName='Exotic Liquids' OR CompanyName='Mayumi ESCAPE'' S'
)