2
Answers

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

Pnkl

Pnkl

12y
2.1k
1
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 :

HeatNoPropertyNameQuantity
1024Cr1.25
1024Ni0.5
1025Si1.5
1025Cr2.0
1030Mn1.0

Result Table :

HeatNoCrSiMnPhMgNi
10241.25----0.5
10252.01.5----
1030--1.0---


Reply Me..

Thanks...............
Answers (2)
Next Recommended Forum