?? lastpurcbyitem.sql
字號:
# Connection: LW-WS01
# Host: localhost
# Saved: 2008-03-17 12:50:50
#
SELECT (SUM(B.QTY*B.NETPRICE)/SUM(B.QTY)) as LASTCOST, B.TRNO,B.NETPRICE,B.ITEMCODE FROM PURC A, purcline B WHERE A.TRDATE=(SELECT MAX(TRDATE) FROM PURC,PURCLINE WHERE PURCLINE.ITEMCODE='ABB-SUR-T' AND PURCLINE.TRNO=PURC.TRNO) AND B.TRNO=A.TRNO AND B.ITEMCODE='ABB-SUR-T' GROUP BY ITEMCODE?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -