这个我不知道怎么做才好 高手进来看看~~~~
SELECT xiongkahao as 胸卡号, xingming as 姓名, xingbie as 性别, danweimc as 单位, gangweimc as 岗位, laobaomc as 劳保, shuliang as 数量, guige as 规格, lingqusj as 领取时间, jldanwei as 计量单位 FROM gerenjilu Where (DATEADD(month,( SELECT Top 1 qixian FROM gangweilaobao WHERE (gangweimc = '" + gangweimcTextBox.Text.ToString() + "')), lingqusj) < GETDATE()) AND (xiongkahao = '" + xiongkahaoTextBox.Text.ToString() + "')
这条语句只能查出一条与劳保名称相对应的劳保用品到期的列表,问题是相同岗位的劳保用品有好几种并且每种的周期都不一样,怎么写语句才能把到期该更换的物品都查询出来?
gangweilaobao表
-------------------------
gangweimc laobaomc qixian
gerenjilu 表
-------------------------
xiongkahao xingming xingbie danweimc gangweimc laobaomc shuliang guige lingqusj jldanwei
其中个人记录表里gangweimc laobaomc和岗位劳保表里的gangweimc laobaomc相对应 也要用到岗位劳保表里的qixian字段和个人记录表里的lingqusj做日期比较
告诉我该怎么做 先谢谢了!!!