SELECT * FROM player_info
WHERE player_match_info_hist.player_id (+)=player_info.player_id
AND player_info.player_id = 1660
AND player_match_info_hist.game_kind = 1
AND substr(match_seq_no, 1, 4) = 2006
试试这样呢
SELECT * FROM player_info
LEFT JOIN player_match_info_hist ON player_match_info_hist.player_id =player_info.player_id AND substr(match_seq_no, 1, 4) = 2006
WHERE player_info.player_id = 1660
AND player_match_info_hist.game_kind = 1
是这样解决的!