1> select * from mi_la_data where rid=0 and fid=1 and element_type='h corrector' 2> go rid fid slot element_name element_type s_value alpha_x beta_x psi_x disp_x d_prime_x alpha_y beta_y psi_y disp_y d_prime_y ----------- ----------- ----------- ---------------------------------------- -------------------- --------------------------- --------------------------- --------------------------- --------------------------- --------------------------- --------------------------- --------------------------- --------------------------- --------------------------- --------------------------- --------------------------- 0 1 29 H102 h corrector 34.233334 -2.365197 53.367455 0.256006 0.000775 0.001411 0.659816 11.683276 0.238133 0.000000 0.000000 0 1 81 H104 h corrector 69.001534 -2.342431 53.729412 0.509072 0.073679 0.003171 0.572241 11.575409 0.490763 0.000000 0.000000 0 1 113 H106 h corrector 94.649223 -1.743262 28.623053 0.760908 -0.881805 -0.079719 0.736759 7.412564 0.707096 0.000000 0.000000 ...... 0 1 4312 H640 h corrector 3292.973389 -1.717586 28.629421 26.167042 -0.945423 -0.037132 0.676538 7.171122 25.148762 0.000000 0.000000 0 1 4344 H100 h corrector 3318.906006 -3.169752 51.864185 26.423679 -0.072389 -0.004466 0.807765 12.105654 25.412365 0.000000 0.000000 (105 rows affected)