mysql - 多个表的 JOIN 语句不起作用

Question

我昨晚刚开始学习SQL。我在使用多个 JOIN 语句显示数据时遇到问题。我有的表是:

Table: CUSTOMER
Contains CustomerID, Country, Last Name

Table: TRANS
Contains CustomerID, TransactionID, DateSold, WorkID

Table: WORK
Contains WorkID, Title, Description

这是我的查询:

Select CUSTOMER.LastName, CUSTOMER.CustomerID, WORK.WorkID, 
        Description, Title

FROM CUSTOMER JOIN TRANS
        ON CUSTOMER.CustomerID = TRANS.CustomerID

JOIN WORK
        ON TRANS.WorkID = WORK.WorkID

WHERE DateSold = '11/17/2014'

GROUP BY CUSTOMER.CustomerID, TRANS.CustomerID, CUSTOMER.LastName,
         WORK.WorkID, Title, DateSold, Description

请注意，在 select 语句中，我故意省略了 GROUP BY 语句中出现的一些项目，只是为了这篇文章。 (将它们包含在 SELECT 语句中不会导致程序正确执行。)

显示的只是 GROUP BY 语句，但没有实际数据。请帮助我解决我做错的事情。谢谢。

Answer 1

使用mysql中的STR_TO_DATE函数转换日期字符串。

WHERE DateSole = STR_TO_DATE('11/17/2014', '%m/%d/%Y')