我在mysql中有两个表:matches和teams,matches有列home_team和away_team,它们与表teams.team_id中的fk相连。代码 SELECT matches.home_team, matches.away_team, teams.name as home, teams.name as
away FROM matches
SELECT [CATEGORY], FROM [Group_New_DB].[dbo].>= @StartDate and [OPEN_TIME] < @EndDate + 1) ) AS OpenedCount, FROMINCIDENTSM1]
WHERE ([CLOSE_TIME] >= @StartDate and [CLOSE_TIME] < @EndDate + 1