ID_game | ID_team | points | home ------------------------------------- 1 | 1 | 87 | true ------------------------------------- 1 | 2 | 79 | false
87 | 79
87 --- 79
SELECT a.ID_game, a.ID_team AS Home, a.Points AS [Home Points], b.ID_team AS Away, b.Points AS [Away Points] FROM MyTable a JOIN MyTable b ON a.ID_game = b .ID_game AND a.home = 1 AND b.Home = 0
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)