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 ('MC0001', 'MC0002', 'MC0003')