SELECT
	[dbo].[tbl_lab_information_Request].[IREQ_PID] AS _col_1,
	[dbo].[tbl_lab_information_Result_Items].[IRESI_LN] AS _col_2,
	[dbo].[tbl_lab_information_Result_Items].[IRESI_STATE] AS _col_3,
	count_big( * ) AS _col_4 
FROM
	[dbo].[tbl_lab_information_Request],
	[dbo].[tbl_lab_information_Request_Items],
	[dbo].[tbl_lab_information_Result_Items],
	[dbo].[tbl_lab_setup_Test] 
WHERE
	[dbo].[tbl_lab_information_Result_Items].[IRESI_CODE] = [dbo].[tbl_lab_setup_Test].[Test_Code] 
	AND [dbo].[tbl_lab_information_Request].[IREQ_LN] = [dbo].[tbl_lab_information_Request_Items].[IREQI_LN] 
	AND [dbo].[tbl_lab_information_Request_Items].[IREQI_LN] = [dbo].[tbl_lab_information_Result_Items].[IRESI_LN] 
	AND [dbo].[tbl_lab_information_Request_Items].[IREQI_CODE] = [dbo].[tbl_lab_information_Result_Items].[IREQI_CODE] 
GROUP BY
	[dbo].[tbl_lab_information_Request].[IREQ_PID],
	[dbo].[tbl_lab_information_Result_Items].[IRESI_LN],
	[dbo].[tbl_lab_information_Result_Items].[IRESI_STATE]