我有一个团队日程表,如下所示:
DBO.SCHEDULE
Game1_Time | Game1_Home_Team | Game1_Away_Team
===================================================
12:00:00 | 1 | 2
我想将团队值替换为另一个表中存在的相应团队:
DBO.TEAM
Team_Number | Team_Name
========================
1 | The Monsters
2 | Bug Bites
想要做到这一点:
如何更换1&附表2中的“怪物”&查询结果中出现“Bug Bites”?
Game1_Time | Home Team | Away Team
===================================================
12:00:00 | The Monsters | Bug Bites