<font face="Times New Roman" >
客户背景：客户是做点钞机的
<font face="Times New Roman" >
客户需求：要查询中向财贸双全中的“价格跟踪”表
<font face="Times New Roman" >
客户软件版本：财贸双全普及版<font face="Times New Roman">80
<font face="Times New Roman" >
处理方法：
因为财贸双全普及版<font face="Times New Roman">80中没有价格跟踪这张报表。
所以让客户进入查询分析器<font face="Times New Roman"> 找到帐套，输入<font face="Times New Roman">sql语句：
<font face="Times New Roman">select d.fullname AS 单位<font face="Times New Roman">,d.person as 联系人<font face="Times New Roman">,d.area as 电话<font face="Times New Roman">,d.telandaddress as 地址<font face="Times New Roman">,s.fullname as 商品<font face="Times New Roman">,j.costprice as 最近进价<font face="Times New Roman">,j.saleprice as 最近售价<font face="Times New Roman">
<font face="Times New Roman" >from price as j join ptype as s on j.ptypeid=s.typeid join btype as d on j.btypeid=d.typeid
然后执行
结果如下
应用效果<font face="Times New Roman"> ：变通处理财贸双全普及版<font face="Times New Roman">80 中没有价格跟踪报表的问题 |
