查询盘点时未盘到的吉他
制四课未盘点到的吉他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')
页:
[1]