SET @SubGroupCode = '106';
--1068คือ subGroupCode (SET @ใช้กับMYSQL])
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;