Hello Guys,
I have Three Table Name PropertyMaster,HeatNoMaster,CombineTable and I want to answer like 'ResultTable'
from these Table using query.
| |
| |
| 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...............
Chetan KumarPosted Oct 22, 2012, 7:18 AM
Please try below query
PnklPosted Oct 22, 2012, 8:23 AM