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_code IN (#'248','249','250')
	lab_items_sub_group_list.lab_items_sub_group_code ='250'
ORDER BY
	lab_items_sub_group_code ASC, 
	lab_items.display_order ASC
	
	
	
	
---For IN LIST(XX,XXX)
/*
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(
	/*'247'
			)
ORDER BY
	lab_items_sub_group_code ASC, 
	lab_items.display_order ASC

*/