查询盘点时未盘到的吉他

sylinx_yqg

制四课未盘点到的吉他

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')