求SQL 语句在易的写法

我是小白我怕谁

select  so_saleorder_b.csaleid ,so_saleorder_b.pk_corp , so_saleorder_b.cinventoryid,so_saleorder_b.nnumber,so_saleorder_b.frowstatus  ,so_sale.pk_corp ,so_sale.vreceiptcode ,so_sale.dbilldate,so_sale.ccustomerid ,bd_invbasdoc.pk_invbasdoc ,bd_invbasdoc.invcode,bd_invbasdoc.invname,bd_invbasdoc.invspec,bd_invbasdoc.invtype,bd_cubasdoc.custname
from  so_saleorder_b
join so_sale on so_sale.csaleid=so_saleorder_b .csaleid
join bd_invbasdoc on bd_invbasdoc .pk_invbasdoc =so_saleorder_b .cinvbasdocid
join bd_cumandoc on bd_cumandoc.pk_cumandoc=so_sale.ccustomerid
join bd_cubasdoc on bd_cubasdoc.pk_cubasdoc=bd_cumandoc.pk_cubasdoc
where bd_invbasdoc.invcode='SD1PCH1S0025'and so_saleorder_b.frowstatus='2'and  so_sale.fstatus='2'
and so_sale.dbilldate >='2024-01-01'and so_sale.dbilldate <='2025-05-01'
AND bd_cubasdoc.custname  NOT IN ('01','03')

求 在易当中的文本  怎么写  格式提示不对

小书

如上图，sql语句是一样的，拼接而已。

辽阳小哲

具体报什么错误，可以尝试语句设置常量，

目前看你发出来的语句本身就有错误,

where条件后的 and 没有留空格

lipzzzz

lity2310

select so_saleorder_b.csaleid ,so_saleorder_b.pk_corp , so_saleorder_b.cinventoryid,so_saleorder_b.nnumber,so_saleorder_b.frowstatus ,so_sale.pk_corp ,so_sale.vreceiptcode ,so_sale.dbilldate,so_sale.ccustomerid ,bd_invbasdoc.pk_invbasdoc ,bd_invbasdoc.invcode,bd_invbasdoc.invname,bd_invbasdoc.invspec,bd_invbasdoc.invtype,bd_cubasdoc.custname from so_saleorder_b join so_sale on so_sale.csaleid=so_saleorder_b .csaleid join bd_invbasdoc on bd_invbasdoc .pk_invbasdoc =so_saleorder_b .cinvbasdocid join bd_cumandoc on bd_cumandoc.pk_cumandoc=so_sale.ccustomerid join bd_cubasdoc on bd_cubasdoc.pk_cubasdoc=bd_cumandoc.pk_cubasdoc where bd_invbasdoc.invcode='SD1PCH1S0025' and so_saleorder_b.frowstatus='2' and so_sale.fstatus='2' and so_sale.dbilldate >='2024-01-01' and so_sale.dbilldate <='2025-05-01' AND bd_cubasdoc.custname NOT IN ('01','03')

青春已不再

直接放在文本常量里面不就好了！用文本替换需要改动的值就好