Select
[UUT_RESULT].[START_DATE_TIME],
[STEP_RESULT].[STEP_NAME],
[PROP_RESULT].[NAME],
[PROP_NUMERICLIMIT].[COMP_OPERATOR],
[PROP_NUMERICLIMIT].[LOW_LIMIT],
[PROP_RESULT].DATA,
[PROP_NUMERICLIMIT].[HIGH_LIMIT],
[PROP_NUMERICLIMIT].UNITS,
[STEP_RESULT].STATUS As STATUS
From
(([UUT_RESULT] Inner Join
[STEP_RESULT] On [STEP_RESULT].[UUT_RESULT] = [UUT_RESULT].ID) Inner Join
[PROP_RESULT] On [PROP_RESULT].[STEP_RESULT] = [STEP_RESULT].ID) Inner Join
[PROP_NUMERICLIMIT] On [PROP_NUMERICLIMIT].[PROP_RESULT] = [PROP_RESULT].ID
where [UUT_RESULT].[UUT_SERIAL_NUMBER] = '05981234' order by [Step_Result].[ORDER_NUMBER],[STEP_RESULT].[STEP_INDEX],[PROP_Result].[ORDER_NUMBER]
Bill Lewis
