DECLARE @Test_Profile_Code VARCHAR(10) 
SET @Test_Profile_Code = 'MC0001'

SELECT t.Test_Code, t.Test_Name, t.Test_His_Code, t.Test_Checkup_Code
FROM dbo.tbl_lab_setup_Test t
INNER JOIN dbo.tbl_lab_setup_Test_Profile tp
ON t.Test_Code = tp.Test_Item_Code
WHERE tp.Test_Profile_Code = @Test_Profile_Code