I want Data-table Result from other Table using query in Below Format

Question

Hello Guys,

I have Three Table Name PropertyMaster,HeatNoMaster,CombineTable and I want to answer like 'ResultTable'

 

from these Table using query.

PropertyMaster

ChemProperty

Cr

SI

Mn

Ph

Mg

Ni

HeatNoMaster

HeatNo

1024

1025

1030

CombineTable :

HeatNo	PropertyName	Quantity
1024	Cr	1.25
1024	Ni	0.5
1025	Si	1.5
1025	Cr	2.0
1030	Mn	1.0

Result Table :

HeatNo	Cr	Si	Mn	Ph	Mg	Ni
1024	1.25	-	-	-	-	0.5
1025	2.0	1.5	-	-	-	-
1030	-	-	1.0	-	-	-

Reply Me..

Thanks...............