SELECT BasData.商品名称, BasData.商品编号, (depot0.数量+depot1.数量+depot2.数量+depot4.数量+depot3.数量) as 数量1 FROM depot0,depot1,depot2 depot3,depot4 where 商品编号="234";
看看这样行不行: SELECT a.商品名称, a.商品编号, (depot0.数量+depot1.数量+depot2.数量+depot4.数量+depot3.数量) as 数量1 FROM basdata a,depot0 ,depot1,depot2 depot3,depot4 where depot0.商品编号=a.商品编号 and depot1.商品编号=a.商品编号 and depot2.商品编号=a.商品编号 and depot3.商品编号=a.商品编号 and depot4.商品编号=a.商品编号 and a.商品编号='234'
From BasDatawhere BasData.商品编号="234";FieldByName('数量1').Valuetry...
还有basdata是什么东西??
还有,where里面应该加上BasData和其他表的关联条件。
不然你要sql怎么选?人脑都搞不清了,更别说笨笨的电脑
好好学习一下SQL语句吧!
SELECT a.商品名称, a.商品编号, (depot0.数量+depot1.数量+depot2.数量+depot4.数量+depot3.数量) as 数量1 FROM
basdata a,depot0 ,depot1,depot2 depot3,depot4
where depot0.商品编号=a.商品编号
and depot1.商品编号=a.商品编号
and depot2.商品编号=a.商品编号
and depot3.商品编号=a.商品编号
and depot4.商品编号=a.商品编号
and a.商品编号='234'