 加好友  发短信
等级：五尾狐
帖子：1031
积分：7237
威望：0
精华：0
注册：2008/9/1 22:34:00
|
 Post By：2013/12/27 14:44:00 [只看该作者]
以下是引用Bin在2013-12-27 14:30:00的发言：SELECT parent_part as 内部编码,child_part,Left(unit_qty,4) As 数量,bom_sort As 排序,{ov_part}.item_no As 物料编码,{ov_part}.part_name As 名称,{ov_part}.part_spec As 规格,{obas_part1}.bom_draw_no As 图号,{obas_part1}.bom_draw_no_wf as 备注,wf_zh as 珠号,{obas_part1}.bom_cbdj as 单价,bomjj as 金额,{obas_part1}.bom_cbdjrem as 价格备注,base_name as 单位 (((from {obom_stru2} INNER JOIN {ov_part} on {obom_stru2}.child_part = {ov_part}.part_no) INNER JOIN {obas_part1} on {obom_stru2}.child_part = {obas_part1}.part_no) INNER JOIN {obas_base_code} on {ov_part}.bom_unit_no = {obas_base_code}.base_code) where {obas_base_code}.code_type = '115'and parent_part = 'O0000000000000025153' ORDER BY 排序
还是不行请上例子,纸上不谈兵!
 此主题相关图片如下：出错2.png 
|
|
