select * from (SELECT danglist.HQ ,
danglist.dh ,
danglist.PONO ,
danglist.SL ,
danglist.DW ,
danglist.long ,
danglist.wide ,
danglist.high ,
danglist.back_high ,
danglist.DKSN ,
danglist.paper ,
danglist.JJ ,
danglist.JD ,
danglist.JC ,
danglist.DJ ,
dingDang.kwcode ,
dingDang.old_dh ,
dingDang.jhrq ,
已出口数 =
(select sum(outsn) from qhd_list where qhd_list.ddh =danglist.ID)
FROM danglist ,
dingDang
WHERE ( danglist.dh = dingDang.DH ) ) aa where danglist.dksn <>danglist.已出口数
danglist.dh ,
danglist.PONO ,
danglist.SL ,
danglist.DW ,
danglist.long ,
danglist.wide ,
danglist.high ,
danglist.back_high ,
danglist.DKSN ,
danglist.paper ,
danglist.JJ ,
danglist.JD ,
danglist.JC ,
danglist.DJ ,
dingDang.kwcode ,
dingDang.old_dh ,
dingDang.jhrq ,
已出口数 =
(select sum(outsn) from qhd_list where qhd_list.ddh =danglist.ID)
FROM danglist ,
dingDang
WHERE ( danglist.dh = dingDang.DH ) ) aa where danglist.dksn <>danglist.已出口数
aa where danglist.dksn <>danglist.已出口数
是什么意思?
danglist.dh ,
danglist.PONO ,
danglist.SL ,
danglist.DW ,
danglist.long ,
danglist.wide ,
danglist.high ,
danglist.back_high ,
danglist.DKSN ,
danglist.paper ,
danglist.JJ ,
danglist.JD ,
danglist.JC ,
danglist.DJ ,
dingDang.kwcode ,
dingDang.old_dh ,
dingDang.jhrq ,
已出口数 =
(select sum(outsn) from qhd_list where qhd_list.ddh =danglist.ID)
FROM danglist ,
dingDang
WHERE ( danglist.dh = dingDang.DH ) ) aa where danglist.dksn <> aa.已出口数
danglist.dh ,
danglist.PONO ,
danglist.SL ,
danglist.DW ,
danglist.long ,
danglist.wide ,
danglist.high ,
danglist.back_high ,
danglist.DKSN ,
danglist.paper ,
danglist.JJ ,
danglist.JD ,
danglist.JC ,
danglist.DJ ,
dingDang.kwcode ,
dingDang.old_dh ,
dingDang.jhrq ,
已出口数 =
(select sum(outsn) from qhd_list where qhd_list.ddh =danglist.ID)
FROM danglist ,
dingDang
WHERE ( danglist.dh = dingDang.DH ) ) aa
where dksn <>已出口数
danglist.dh ,
danglist.PONO ,
danglist.SL ,
danglist.DW ,
danglist.long ,
danglist.wide ,
danglist.high ,
danglist.back_high ,
danglist.DKSN ,
danglist.paper ,
danglist.JJ ,
danglist.JD ,
danglist.JC ,
danglist.DJ ,
dingDang.kwcode ,
dingDang.old_dh ,
dingDang.jhrq ,
已出口数 =
(select sum(outsn) from qhd_list where qhd_list.ddh =danglist.ID)
FROM danglist ,
dingDang
having ( danglist.dh = dingDang.DH ) and
(danglist.dksn <>(select sum(outsn) from qhd_list where qhd_list.ddh =danglist.ID)
SELECT danglist.HQ ,
danglist.dh ,
danglist.PONO ,
danglist.SL ,
danglist.DW ,
danglist.long ,
danglist.wide ,
danglist.high ,
danglist.back_high ,
danglist.DKSN ,
danglist.paper ,
danglist.JJ ,
danglist.JD ,
danglist.JC ,
danglist.DJ ,
dingDang.kwcode ,
dingDang.old_dh ,
dingDang.jhrq ,
已出口数 =
(select sum(outsn) from qhd_list where qhd_list.ddh =danglist.ID)
FROM danglist ,
dingDang
WHERE ( danglist.dh = dingDang.DH )
)aaaaaaa
where (dksn <>已出口数)
danglist.dh ,
danglist.PONO ,
danglist.SL ,
danglist.DW ,
danglist.long ,
danglist.wide ,
danglist.high ,
danglist.back_high ,
danglist.DKSN ,
danglist.paper ,
danglist.JJ ,
danglist.JD ,
danglist.JC ,
danglist.DJ ,
dingDang.kwcode ,
dingDang.old_dh ,
dingDang.jhrq ,
(select sum(outsn) from qhd_list where qhd_list.ddh =danglist.ID) 已出口数
FROM danglist ,
dingDang
WHERE ( danglist.dh = dingDang.DH ) and (danglist.dksn <>danglist.已出口数)