Foxtable(狐表)用户栏目专家坐堂 → sql语句出错


  共有4202人关注过本帖平板打印复制链接

主题:sql语句出错

帅哥哟,离线,有人找我吗?
yankunhao
  1楼 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信
等级:五尾狐 帖子:1019 积分:7155 威望:0 精华:0 注册:2008/9/1 22:34:00
sql语句出错  发帖心情 Post By:2013/12/27 14:10: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 排序

 

 


图片点击可在新窗口打开查看此主题相关图片如下:出错1.png
图片点击可在新窗口打开查看

 回到顶部
总数 20 1 2 下一页