I have two tables Names as like TableHead and Tableasist
From these above two tables i want to get one table result like below...
i explained result table column conditions in below
Conditions: Get all records where MICR04 value 122 and above this is first condition
Date time: this column should be get as it is no condition
Parameter Name : I have to change column name as parameter and all values fill like MICR04(header of first table of 2nd header)
Set Value: this value get from Tableasist (2nd Table) of Set Temp value 120.. so should be filled 120 in all rows like below
Process Value : process value means MICR04 column value where we get all rows
HighLimt: This value fixed like 150 (Put as it is 150)
Deviation: devation = (High Limit – Process Value)
Event: we can take Event value from first table as usual
these result table unknown columns can add after Event in first table so that i will append these table to gridview. i will hide remaining columns.