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, 
	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
WHERE
	lab_items_sub_group_list.lab_items_sub_group_code = ---67
ORDER BY
	lab_items.display_order ASC
	
	
	
	---#BIG_FISH_BY_GEE