การดึง Ref. จาก SETUP TEST

PHOTO EMBED

Thu Mar 09 2023 10:18:13 GMT+0000 (Coordinated Universal Time)

Saved by @HUMRARE7 #sql

SELECT
	tbl_lab_setup_Test.[Test_Code],
	tbl_lab_setup_Test.Test_Name,
	[Sex_Description],
	[Age_Text],
	[Test_Reference_Text],
	[Unit_Title],
	[Test_Reference_Cri1],
	[Test_Reference_Cri2]
FROM
	[LAB_DB].[dbo].[view_lab_setup_Test_Numeric_Reference]
JOIN tbl_lab_setup_Test ON [view_lab_setup_Test_Numeric_Reference].Test_Code = tbl_lab_setup_Test.Test_Code
WHERE
	Test_Reference_Id IS NOT NULL
AND tbl_lab_setup_Test.Test_Inactive = '0'
ORDER BY
	tbl_lab_setup_Test.Test_Code,
	Test_Reference_Id
content_copyCOPY