Saturday, September 28, 2013

TSQL For foreign key and Primary key

I have 2 tables with the following Fields



























IdArmourIdShieldId
11011
21211
31213

and Table Number 2




























IdMaterialNameIsArmour
10A1True
11S1False
12A2True
13S2False

How can i get TSQl for the following result























IdArmourNameShieldName
1A1S1
2A2S1
3A2

S2


Thank you



No comments:

Post a Comment