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 ('63','74','75','111')
ORDER BY
	lab_items_sub_group_code ASC, 
	lab_items.display_order ASC