By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
Msg 4104 Level 16 State 1 Line 1
The multi-part identifier "a.id" could not be bound.
id | foo | id | foo | id | id |
---|---|---|---|---|---|
1 | 1 | 1 | 1 | 10 | 1 |
1 | 1 | 1 | 1 | 20 | 1 |
2 | 2 | 2 | 2 | 10 | 2 |
2 | 2 | 2 | 2 | 20 | 2 |