SELECT tlt.Test_Code, tlt.Test_Name, tlt.Test_His_Code ,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 IN ('MC050P','MC050P','MC044P','MC047P')