如何使用mysql在子查询结果中设置默认VALUESELECTp.`id`,p.`name`,p.`class_name`,cpd.`status_team`,cpd.`home`,cpd.`guest`,cpd.`mvp`,cpd.`oscar`,cpd.`wam`,cpd.`status`,cpd.`added_date`,(SELECTresultFROMresult_cardsWHERE`id`=cpd.`result`)ASDEFAULT(`result`)FROM`cron_players_data`cpdINNERJOIN`players`pONcpd.`player_i