SELECT tlt.Test_Code, tlt.Test_Name, tlt.Test_His_Code 
FROM dbo.tbl_lab_setup_Test_Profile tltp 
INNER JOIN dbo.tbl_lab_setup_Test tlt ON tltp.Test_Item_Code = tlt.Test_Code 
WHERE tltp.Test_Profile_Code IN ('CH046','CH046A','CH046V')
ORDER BY Test_Profile_Code ASC

/*
SELECT tlt.Test_Code, tlt.Test_Name, tlt.Test_His_Code , tlt.Test_Checkup_Code 
FROM dbo.tbl_lab_setup_Test_Profile tltp 
INNER JOIN dbo.tbl_lab_setup_Test tlt ON tltp.Test_Item_Code = tlt.Test_Code 
WHERE tltp.Test_Profile_Code = ('XXX')
ORDER BY Test_Profile_Code ASC
*/