php - 这个 MySQL 连接查询有什么问题

Question

我有一个 breaks 和 clock_in_out 表，我想从两者中获取所有值并将它们加入到它们的 user_id 列中。但是我在 JOIN ON 附近使用的 synatx 不正确，不知道为什么。这是我的查询

SELECT * 
FROM `breaks` 
WHERE `user_id` = 1 
AND `in_date` LIKE '%2015-03-03%' 
AND `out_date` LIKE '%2015-03-03%' 
JOIN `clock_in_out` ON `breaks`.`user_id` = `clock_in_out`.`user_id` 
WHERE `loggedin_date` 
LIKE '%2015-03-03%' 
AND `loggedout_date` LIKE '%2015-03-03%'

Answer 1

WHERE 子句应该在 JOIN 之后:

SELECT * 
FROM `breaks` JOIN 
     `clock_in_out` ON `breaks`.`user_id` = `clock_in_out`.`user_id`
WHERE `user_id` = 1 
  AND `in_date` LIKE '%2015-03-03%' 
  AND `out_date` LIKE '%2015-03-03%' 
  AND `loggedin_date` LIKE '%2015-03-03%' 
  AND `loggedout_date` LIKE '%2015-03-03%'