mysql - 错误 1064 - 使用 IN 语句

Question

列出订购 Apple 笔记本电脑的客户姓名(选择您自己的加入类型)。我有美食表客户、订单行、订单表和产品。我不断收到此错误

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''product' where product_name = 'Apple Laptop'))) LIMIT 0, 25' at line 4

select customer.cust_name
from customer
where customer.cust_id in (
        select cust_id
        from ordertable
        where order_id in (
                select order_id
                from orderline
                where product in (
                        select product_id
                        from 'product'
                        where product_name = 'Apple Laptop'
                        )
                )
        )

Answer 1

删除最后一个 select 语句中“product”的引号。它是表的名称，因此不需要引号。