|
<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 中没有价格跟踪报表的问题 |
0 条回帖
