Pnkl

Pnkl

  • NA
  • 114
  • 66.1k

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

Oct 22 2012 4:51 AM
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)