补充一下,就是想实现这样的功能
t1.number1 t2.boxCode sum(jiage*shuliang)
1 .. ..
2 .. ..
3 .. ..
说明:
boxCode=select boxCode from t2,t1 where t2.number1=t1.number1 and t2.last='1'
sum(jiage*shuliang)=select (jiage*shuliang) as mTotal from t3 as t3,
t2 as t2,t1 as t1 where t3.numer1=t1.number1
and t3. number1=t2.number1
and t3.id2=t2.id2 and t2.last='1'
能看懂么?请问如何正确些Sql语句?
t1.number1 t2.boxCode sum(jiage*shuliang)
1 .. ..
2 .. ..
3 .. ..
说明:
boxCode=select boxCode from t2,t1 where t2.number1=t1.number1 and t2.last='1'
sum(jiage*shuliang)=select (jiage*shuliang) as mTotal from t3 as t3,
t2 as t2,t1 as t1 where t3.numer1=t1.number1
and t3. number1=t2.number1
and t3.id2=t2.id2 and t2.last='1'
能看懂么?请问如何正确些Sql语句?
FROM dbo.t1 t1 INNER JOIN
dbo.t2 t2 ON t1.number1 = t2.number1 INNER JOIN
dbo.t3 t3 ON t2.id2 = t3.id2
WHERE (t2.[last] = '1')
(Select SUM(t3.jiage * t3.shuliang) from T3 where id2 = b.id2) AS mTotal
FROM dbo.t1 a INNER JOIN
dbo.t2 b ON a.number1 = b.number1
WHERE (t2.[last] = '1')
(Select SUM(t3.jiage * t3.shuliang) from T3 where id2 = b.id2) AS mTotal
FROM dbo.t1 a INNER JOIN
dbo.t2 b ON a.number1 = b.number1
WHERE (b.[last] = '1')