Jhon ABhu

Jhon ABhu

  • NA
  • 57
  • 4.6k

Get table with non table column(Created by own names) names through SQ

Feb 2 2021 5:27 PM

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

Select * From TableHead where MICR04 >= '122'

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.


Answers (1)