查询1.qpr

随着我国教育产业化的飞速发展

SELECT DISTINCT Yqsb.*;
 FROM  物资管理库!yqsb RIGHT OUTER JOIN 物资管理库!jieyong ;
   ON  Yqsb.yqbh = Jieyong.yqbh;
 WHERE Jieyong.jyrq IS NOT NULL;
   AND Jieyong.ghrq IS NULL