mysql like子查询语句_mysql – 使用’LIKE’和SQL子查询的结果
首先,此查询不应该正常工作：SELECT *From CustomersWHERE Customers.ContactName = (SELECT FirstNamefrom Employees as E, orders as OWHERE LIMIT 1);因为WHERE LIMIT 1不是正确的SQL.而且,您应该学会使用正确的连接语法.据推测,你打算：SELECT c.*From Custo...
