摘要:
SELECT * FROM @USE U LEFT JOIN (SELECT * FROM SUBINVENTORY WHERE SUBWAREHOUSE=@SUBWAREHOUSE) S ON U.ITEMNUM=S.ITEMNUM SELECT * FROM @USE U LEFT JOIN SUBINVENTORY S ON U.ITEMNUM=S.ITEMNUM WHERE ... 阅读全文
posted @ 2006-12-06 15:29 Wayne2082 阅读(182) 评论(0) 推荐(0) 编辑