SET @SubGroupCode = '106';          ---แทน'106'ด้วยเลข(lab_items_sub_group_code) 
SELECT
  sg_list.lab_items_sub_group_code AS SubGroupCode,
  sg.lab_items_sub_group_name AS SubGroupName,
  li.ecode AS ItemECode,
  li.lab_items_name AS ItemName,
  li.lab_items_code AS ItemCode,
  li.display_order AS DisplayOrder,
  li.lab_items_normal_value AS NormalValue,
  li.possible_value AS PossibleValue,
  li.lab_items_unit AS Unit 
FROM
  lab_items_sub_group_list AS sg_list
  INNER JOIN lab_items AS li ON li.lab_items_code = sg_list.lab_items_code
  INNER JOIN lab_items_sub_group AS sg ON sg_list.lab_items_sub_group_code = sg.lab_items_sub_group_code 
WHERE
  sg_list.lab_items_sub_group_code = @SubGroupCode 
ORDER BY
  SubGroupCode ASC,
  DisplayOrder ASC;