他等於他，然後再抓出他的值等於另個資料表的他

摘要：他等於他，然後再抓出他的值等於另個資料表的他

CREATE PROCEDURE proc_getWorkingHourOfADay(@employID varchar(10))

AS

SELECT MK012 AS WorkingHourOfADay FROM PALMK

WHERE(MK001=(SELECT MV027 FROM CMSMV

WHERE (MV001=@employID)))

GO