摘要:他等於他,然後再抓出他的值等於另個資料表的他
CREATE PROCEDURE proc_getWorkingHourOfADay(@employID varchar(10))
AS
SELECT MK012 AS WorkingHourOfADay FROM PALMK
WHERE(MK001=(SELECT MV027 FROM CMSMV
WHERE (MV001=@employID)))
GO
摘要:他等於他,然後再抓出他的值等於另個資料表的他
CREATE PROCEDURE proc_getWorkingHourOfADay(@employID varchar(10))
AS
SELECT MK012 AS WorkingHourOfADay FROM PALMK
WHERE(MK001=(SELECT MV027 FROM CMSMV
WHERE (MV001=@employID)))
GO