'Join a superset table with subset
I am on MSSQL. I have two tables. One has ID and row values:
ID
1
2
3
4
5
Another table has ID and Amount
ID, Amount
3, 30
4, 40
5, 50
I want a query that will give me:
ID, Amount
1, 0
2, 0
3, 30
4, 40
5, 50
Any ideas on how I can accomplish this? Thanks!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|