具体的SQL 语句如下:
请大虾指点一下,Delphi中 次语句 编译通过 但是执行时提示"GS"."ODE"标示符无效 出错。Delphi 中改如何去写。select gs.code ,gs.code2 , gs.name ,gs.rtlprc ,w.code ,w.name ,bb.xldm ,bb.xlmc ,sum(b.qty)
from businvs b ,warehouse w,goods gs,bb_cw_splbb bb
where b.wrh = w.gid and b.gdgid = gs.gid
and gs.sort = bb.xldm and b.qty <> 0
and ((bb.xldm ='37120' and w.code = '03') or (w.code ='03' and gs.code='3712000125' )
or w.code = '03')
group by w.code,w.name,gs.ode,gs.code2,gs.name,gs.rtlprc,bb.xldm,bb.xlmc
order by gs.code DelphiSQL
请大虾指点一下,Delphi中 次语句 编译通过 但是执行时提示"GS"."ODE"标示符无效 出错。Delphi 中改如何去写。select gs.code ,gs.code2 , gs.name ,gs.rtlprc ,w.code ,w.name ,bb.xldm ,bb.xlmc ,sum(b.qty)
from businvs b ,warehouse w,goods gs,bb_cw_splbb bb
where b.wrh = w.gid and b.gdgid = gs.gid
and gs.sort = bb.xldm and b.qty <> 0
and ((bb.xldm ='37120' and w.code = '03') or (w.code ='03' and gs.code='3712000125' )
or w.code = '03')
group by w.code,w.name,gs.ode,gs.code2,gs.name,gs.rtlprc,bb.xldm,bb.xlmc
order by gs.code DelphiSQL
~~~~~~你先把SQL放到ACCESS或SQL SERVER查询分析器里执行一下试试看对不对