查询1.qpr

来自「企业生产库房管理系统,主要企业的材料进出管理,自动生成报表.」· QPR 代码 · 共 7 行

SELECT Bhmc.零件编号, Bhmc.零件名称, Bhmc.规格型号, Ckdj.领料数量,;
  Ckdj.领料人, Ckdj.领料日期, Ckdj.ysdd, Ckdj.ys8a, Ckdj.ys88, Ckdj.ys88a,;
  Ckdj.网络, Ckdj.yswf, Ckdj.电源, Ckdj.载波, Ckdj.自动化, Ckdj.维护, Ckdj.能创,;
  Ckdj.其它, Ckdj.备注;
 FROM  kfgl!bhmc INNER JOIN kfgl!ckdj ;
   ON  Bhmc.零件编号 = Ckdj.零件编号