---SMallfish ATLIAS version
SELECT lisg.lab_items_sub_group_code,
       lisg.lab_items_sub_group_name,
       li.ecode,
       li.lab_items_name,
       li.lab_items_code,
       li.display_order,
       li.lab_items_normal_value,
       li.possible_value,
       li.lab_items_unit
FROM lab_items_sub_group_list AS lisgl
INNER JOIN lab_items AS li ON li.lab_items_code = lisgl.lab_items_code
INNER JOIN lab_items_sub_group AS lisg ON lisg.lab_items_sub_group_code = lisgl.lab_items_sub_group_code
WHERE lisgl.lab_items_sub_group_code IN ('79','80')



/*
SELECT lisg.lab_items_sub_group_code,
       lisg.lab_items_sub_group_name,
       li.ecode,
       li.lab_items_name,
       li.lab_items_code,
       li.display_order,
       li.lab_items_normal_value,
       li.possible_value,
       li.lab_items_unit
FROM lab_items_sub_group_list AS lisgl
INNER JOIN lab_items AS li ON li.lab_items_code = lisgl.lab_items_code
INNER JOIN lab_items_sub_group AS lisg ON lisg.lab_items_sub_group_code = lisgl.lab_items_sub_group_code
WHERE lisgl.lab_items_sub_group_code IN ('251',
                                         '252',
                                         '253')
ORDER BY lisg.lab_items_sub_group_code ASC,
         li.display_order ASC;
*\