php - Mysql 对于具有相似 where 子句的 2 个查询返回不同的结果

Question

当我输入以下内容时:

SELECT *
FROM `events`
WHERE `tournament` = 'Super 15'
AND `round` = '13'

我回来了:

当我插入时:

SELECT events.event_id,events.tournament, events.team1, events.team2,events.round,
       events.event_date, events.venue, picks.pick
FROM  events 
INNER JOIN picks ON  events.event_id = picks.event_id
where
events.tournament="Super 15" AND events.round="13"

我得到:

表 1:

表 2:

知道为什么对于具有相似 WHERE 子句的两个查询，我会得到不同的结果

Answer 1

使用以下查询获得相同的结果:-

SELECT events.event_id,events.tournament, events.team1, events.team2,events.round,
       events.event_date, events.venue, picks.pick
FROM  events 
LEFT JOIN picks ON  events.event_id = picks.event_id
where
events.tournament="Super 15" AND events.round="13"