I have 2 tables with the following Fields
Id | ArmourId | ShieldId |
1 | 10 | 11 |
2 | 12 | 11 |
3 | 12 | 13 |
and Table Number 2
Id | MaterialName | IsArmour |
10 | A1 | True |
11 | S1 | False |
12 | A2 | True |
13 | S2 | False |
How can i get TSQl for the following result
Id | ArmourName | ShieldName |
1 | A1 | S1 |
2 | A2 | S1 |
3 | A2 | S2 Thank you |
No comments:
Post a Comment