Farhan Shariff

Farhan Shariff

  • NA
  • 933
  • 238.7k

Max/Mini Value in datatable by comparing with other datatabl

May 26 2014 5:38 AM
I have two datatables table1 and table 5
Table1
Par Name  
Lowest  
Highest  
 lower_limit  
 upper_limit  
Con_3


-0.65

0.03

Con_2


-0.12

0.06

Con_1


-0.41

0.02


Table5
Con_1
Con_3
Con_2


Split
Die_ID
Normal_Inverse
0.0013

0.0018

0.0012    


Stressed

N6K83_12

-2.49897
 
-0.0071  

0.0015  

-0.0005



Ref
N634-10_12

-2.16681
 
-0.0004

0.082

-0.0027



Stressed

N610_15

-1.97699
 


I want to compare lower limit and upper limit from table 1 with corresponding column (Con_1,Con_2,Con_3  from table 5 ) and delete the column in table5 if :

There is no value lesser then lower_limit OR there is no value greater than upper_limit in the table5 column




Answers (3)