//檢查 會員銷貨 QHEAD QITEMS 件數是否相符
SELECT FORMNO,FORMDATE,ATOT FROM `qhead` WHERE QKIND=31 and 
ATOT<>(select sum(UNIT30) from qitems where qhead.FORMNO=qitems.FORMNO)

SELECT DEPTNO,FORMNO,FORMDATE,ATOT FROM `qhead` WHERE (QKIND=31 or QKIND=30) and 
ATOT<>(select sum(UNIT30) from qitems where qhead.FORMNO=qitems.FORMNO)


SELECT FORMNO,FORMDATE,CREATEDATETIME,BANKNAME,ATOT FROM `qhead` WHERE QKIND=31 and 
ATOT<>(select sum(UNIT30) from qitems where qhead.FORMNO=qitems.FORMNO)

//檢查櫃員銷貨
SELECT FORMNO,FORMDATE,CREATEDATETIME,BANKNAME,ATOT FROM `qhead` WHERE QKIND=41 and 
ATOT<>(select sum(UNIT40) from qitems where qhead.FORMNO=qitems.FORMNO)

//檢查門市出貨
SELECT FORMNO,FORMDATE,CREATEDATETIME,BANKNAME,ATOT FROM `qhead` WHERE QKIND=20 and 
ATOT<>(select sum(UNIT20) from qitems where qhead.FORMNO=qitems.FORMNO)


//檢查門市轉貨
SELECT FORMNO,FORMDATE,CREATEDATETIME,BANKNAME,ATOT FROM `qhead` WHERE QKIND=21 and 
ATOT<>(select sum(UNIT20) from qitems where qhead.FORMNO=qitems.FORMNO)

//檢查廠商進貨
SELECT FORMNO,FORMDATE,CREATEDATETIME,BANKNAME,ATOT FROM `qhead` WHERE QKIND=10 and 
ATOT<>(select sum(UNIT10) from qitems where qhead.FORMNO=qitems.FORMNO)