我想了解下国际象棋和跳棋的玩家的身份
playerid game website
a1 chess www.abc.com
a2 checkers www.cba.com
a1 checkers www.abc.com
b2 chess www.abc.com
b1 chess www.abc.com
a3 checkers www.aaa.com
b2 checkers www.abc.com
所需输出(应排除a3和b1)
a1
b2
select game, playerid, website
from player_db
where (game= 'chess' or game= 'checkers') and website='abc.com'
group by playerid ;
这是我的sql,但它似乎无法同时获得这两个游戏.它 Select 国际象棋或跳棋