str:='select boxim.号,boxim.xx1,boxim.xx2,boxim.x3, '
+'shuiya.日期1,shuiya.日期5 as 检测期, '
+'dingdan.订单号,dingdan.订单类型,dingdan.订单日期,dingdan.客户名 '
+'from boxim left join shuiya on (boxim.号=shuiya.号) '
+'left join dingdan on(boxim.订单号=dingdan.订单号)where 1=1';一个LEFT JOIN时不会出错,两个了不知道错在那了,一直提示错误
+'shuiya.日期1,shuiya.日期5 as 检测期, '
+'dingdan.订单号,dingdan.订单类型,dingdan.订单日期,dingdan.客户名 '
+'from boxim left join shuiya on (boxim.号=shuiya.号) '
+'left join dingdan on(boxim.订单号=dingdan.订单号)where 1=1';一个LEFT JOIN时不会出错,两个了不知道错在那了,一直提示错误
明显是)where 1=1'这里没空格,改成:) where 1=1'
再试。
错误提示为操作符丢失,在查询式'(boxim.号=shuiya.号) left join dingdan on(boxim.订单号=dingdan.订单号)where 1=1'中