SELECT lab_items_sub_group_list.lab_items_sub_group_code, lab_items_sub_group.lab_items_sub_group_name, lab_items.ecode, lab_items.lab_items_name, lab_items.lab_items_code, lab_items.display_order, lab_items.lab_items_normal_value, lab_items.possible_value, lab_items.lab_items_unit FROM lab_items_sub_group_list INNER JOIN lab_items ON lab_items.lab_items_code = lab_items_sub_group_list.lab_items_code INNER JOIN lab_items_sub_group ON lab_items_sub_group_list.lab_items_sub_group_code = lab_items_sub_group.lab_items_sub_group_code WHERE #.lab_items_sub_group_code IN (#'248','249','250') lab_items_sub_group_list.lab_items_sub_group_code ='250' ORDER BY lab_items_sub_group_code ASC, lab_items.display_order ASC /* SELECT lab_items_sub_group_list.lab_items_sub_group_code, lab_items_sub_group.lab_items_sub_group_name, lab_items.ecode, lab_items.lab_items_name, lab_items.lab_items_code, lab_items.display_order, lab_items.lab_items_normal_value, lab_items.possible_value, lab_items.lab_items_unit FROM lab_items_sub_group_list INNER JOIN lab_items ON lab_items.lab_items_code = lab_items_sub_group_list.lab_items_code INNER JOIN lab_items_sub_group ON lab_items_sub_group_list.lab_items_sub_group_code = lab_items_sub_group.lab_items_sub_group_code WHERE lab_items_sub_group_list.lab_items_sub_group_code in( '247' ) ORDER BY lab_items_sub_group_code ASC, lab_items.display_order ASC */ /* SELECT lab_items_sub_group_list.lab_items_code, lab_items.lab_items_code, lab_items_sub_group_list.lab_items_sub_group_code, lab_items.lab_items_name, lab_items.ecode, lab_items.display_order FROM lab_items_sub_group_list INNER JOIN lab_items ON lab_items.lab_items_code = lab_items_sub_group_list.lab_items_code WHERE lab_items_sub_group_list.lab_items_sub_group_code = ---80 ORDER BY lab_items.display_order ASC */