22,300
社区成员




-- 参数
DECLARE @s_name nvarchar(10)
DECLARE @dt datetime
SET @s_name = N'张三丰'
SET @dt = '2013-11-26'
-- 查询
SELECT [ziliao].[s_name] 雇员姓名,
[k_data1].[d_work1] 下班时间,
[k_data2].[work2] 上班时间,
[jiaqi].[tianshu] 请假天数
FROM ziliao
LEFT JOIN k_data1
ON k_data1.KID = ziliao.KID
AND k_data1.DATA1 = @dt
LEFT JOIN k_data2
ON k_data2.KID = ziliao.KID
AND k_data2.DATA1 = @dt
LEFT JOIN jiaqi
ON jiaqi.UID = ziliao.KID
AND jiaqi.startdata <= @dt
AND jiaqi.enddata >= @dt
WHERE ziliao.s_name = @s_name