mysql连接查询经典小例题_MySQL

select result.id, t_name as h_name,match_time,result from teams  join result on teams.t_id=result.h_id

select result.id ,t_name as g_name from teams  join result on teams.t_id=result.g_id

select t1.id,h_name,g_name,result,match_time from(select result.id, t_name as h_name,match_time,result from teams  join result on teams.t_id=result.h_id) as t1 join (select result.id ,t_name as g_name from teams  join result on teams.t_id=result.g_id) as t2 on t1.id=t2.id;

select result.id,t1.t_name as h_name ,t2.t_name as g_name ,result,match_time from result join teams as t1 on result.h_id=t1.t_id join teams as t2 on t2.t_id=result.g_id;

select t1.name as p_name,t2.name as son_name from subject as t1 join subject as t2 on t1.id=t2.pid;