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

发表于:2007-06-07来源:作者:点击数: 标签:

CREATE PROCEDURE proc_getWorkingHourOfADay(@employID varchar(10))

 AS

 SELECT MK012 AS WorkingHourOfADay FROM PALMK
  WHERE(MK001=(SELECT MV027 FROM CMSMV
  WHERE (MV001=@employID)))
  
GO

原文转自:http://www.ltesting.net