select teams.team_hk from sheet_stander
join game_stander on sheet_stander.game_id = game_stander.id
join schedule on game_stander.sche_id = schedule.id
join teams on schedule.teamA = teams.id
where sheet_stander.id = 1
先确保选出来的是唯一记录
join game_stander on sheet_stander.game_id = game_stander.id
join schedule on game_stander.sche_id = schedule.id
join teams on schedule.teamA = teams.id
where sheet_stander.id = 1
先确保选出来的是唯一记录
case type
when 1 then
(select teams.team_hk from sheet_stander
join game_stander on sheet_stander.game_id = game_stander.id
join schedule on game_stander.sche_id = schedule.id
join teams on schedule.teamA = teams.id
where sheet_stander.id = 1)--这个条件的结果有多条
when 2 then 'b'
when 3 then 'd'
else 'no'
end
from sheet_stander
where schedule.state=0
when 2 then 'b'
when 3 then 'd'
else 'no'
end
from sheet_stander a left join
( select 1 as tp,teams.team_hk from sheet_stander
join game_stander on sheet_stander.game_id = game_stander.id
join schedule on game_stander.sche_id = schedule.id
join teams on schedule.teamA = teams.id
where sheet_stander.id = 1
) b
on a.type=b.tp
where schedule.state=0
team是@team吧
还是不用CASE,直接分成多个select好些