34,575
社区成员
发帖
与我相关
我的任务
分享
SELECT
M_HINBAN.HNBAN
,M_HINBAN.NENDO
,M_HINBAN.SEASON
,M_HINBAN.ITEM
FROM
M_HINBAN LEFT JOIN M_SHOHIN
ON M_HINBAN.HNBAN = M_SHOHIN.HNBAN
IF @NHBAN_F IS NOT NULL
AND @NHBAN_T IS NOT NULL
BEGIN
WHERE M_HINBAN.HNBAN > = @NHBAN_F
AND M_HINBAN.HNBAN < = @NHBAN_T
END
SELECT
M_HINBAN.HNBAN
,M_HINBAN.NENDO
,M_HINBAN.SEASON
,M_HINBAN.ITEM
FROM
M_HINBAN LEFT JOIN M_SHOHIN
ON M_HINBAN.HNBAN = M_SHOHIN.HNBAN
WHERE M_HINBAN.HNBAN > = isnull(@NHBAN_F,M_HINBAN.HNBAN)
AND M_HINBAN.HNBAN < = isnull(@NHBAN_T,M_HINBAN.HNBAN)