SELECT * FROM player
SELECT * FROM team
-- 笛卡尔积
SELECT * FROM team,player
-- 等值连接
SELECT player_id, player.team_id, player_name, height, team_name FROM player, team WHERE player.team_id = team.team_id
SELECT player_id, a.team_id, player_name, height, team_name FROM player AS a, team AS b WHERE a.team_id = b.team_id
--非等值链接
SELECT p.player_name,p.height,h.height_level FROM player as p,height_grades as h WHERE p.height BETWEEN h.height_lowest and h.height_highest
-- SELECT * FROM player, team where player.team_id = team.team_id(+) sql 92
-- sql 99 左连接,RIGHT JOIN 右连接
SELECT * FROM player LEFT JOIN team on player.team_id = team.team_id