查询盘点时未盘到的吉他

制四课未盘点到的吉他

SELECT a.jtbh, c.ddhm, e.khxh, d.zdbh
FROM jitajh a INNER JOIN
jtscjd b ON a.id = b.id INNER JOIN
dingdan c ON a.dingdanid = c.id INNER JOIN
zhandian d ON b.zdid = d.id INNER JOIN
zscjhmx e ON a.zscjhmxid = e.id
WHERE (a.jtbh NOT IN
(SELECT guitarnumber
FROM pandian)) AND (d.zdbh <> '4P21') AND (e.scxid = 1) AND (d.zdbh <> '4B1')
AND (a.scjq IS NOT NULL)


制四课2008-07-01后未盘点到的吉他

SELECT a.jtbh, c.ddhm, e.khxh, d.zdbh
FROM jitajh a INNER JOIN
jtscjd b ON a.id = b.id INNER JOIN
dingdan c ON a.dingdanid = c.id INNER JOIN
zhandian d ON b.zdid = d.id INNER JOIN
zscjhmx e ON a.zscjhmxid = e.id
WHERE (a.jtbh NOT IN
(SELECT guitarnumber
FROM pandian)) AND (d.zdbh <> '4P21') AND (e.scxid = 1) AND (d.zdbh <> '4B1') AND (a.crsj >= '2008-07-01')
AND (a.scjq IS NOT NULL)

制三课未盘点到的全部吉他
SELECT a.jtbh, c.ddhm, e.khxh, d.zdbh
FROM jitajh a INNER JOIN
jtscjd b ON a.id = b.id INNER JOIN
dingdan c ON a.dingdanid = c.id INNER JOIN
zhandian d ON b.zdid = d.id INNER JOIN
zscjhmx e ON a.zscjhmxid = e.id
WHERE (a.jtbh NOT IN
(SELECT guitarnumber
FROM pandian)) AND (d.zdbh <> '3P21') AND (e.scxid = 2) AND (d.zdbh <> '3B1') AND (d.zdbh <> '3D3')
AND (a.scjq IS NOT NULL)

制三课2008-07-01后未盘点到的吉他
SELECT a.jtbh, c.ddhm, e.khxh, d.zdbh
FROM jitajh a INNER JOIN
jtscjd b ON a.id = b.id INNER JOIN
dingdan c ON a.dingdanid = c.id INNER JOIN
zhandian d ON b.zdid = d.id INNER JOIN
zscjhmx e ON a.zscjhmxid = e.id
WHERE (a.jtbh NOT IN
(SELECT guitarnumber
FROM pandian)) AND (d.zdbh <> '3P21') AND (e.scxid = 2) AND (d.zdbh <> '3B1') AND (d.zdbh <> '3D3')
AND (a.scjq IS NOT NULL) AND (a.crsj >= '2008-07-01')