sele ct b.code as '单据编号',a.date as '入库日期',a.jbr as '经办人',a.note as '备注',
b.qsbh as '起始编号',b.sl as '本数',b.jsbh as '结束编号',b.note as '摘要' from RKZB a left join rkmx b on (a.code = b.code) where YEAR(a.date) = (select YEAR(GETDATE())) ORDER BY a.date,b.code
加好友 
发短信
Post By：2017/3/10 21:41:00 [显示全部帖子]
