请教一个查询SQL的写法,谢谢

下面有两个表,一个是订单表,一个是订单详细表,我想查出某天的商品总数,也就是把amount加起来,
订单表和订单详细表相关联的字段是order_id,请教一下这个SQL语句怎么写,谢谢大家

order_id order_date
2 2011-05-16
3 2011-05-16

order_product_id order_id amount
1 2 100
2 3 100

作者: yifuzhiming   发布时间: 2011-05-25

SQL code
select order_date,sum(amount)
from tb1 A,tb2 B
where A.order_id = B.order_id
group by order_date

作者: rucypli   发布时间: 2011-05-25

select a.order_id,a.order_date,sum(b.amount)
from tb1 A inner join tb2 B
on A.order_id = B.order_id
group by a.order_id,a.order_date

作者: WWWWA   发布时间: 2011-05-25

哇,一条语句就搞定了,厉害,谢谢

作者: yifuzhiming   发布时间: 2011-05-25

select order_date,sum(amount)
from table1 a inner join table2 b on a.order_id = b.order_id
group by order_date

作者: ACMAIN_CHM   发布时间: 2011-05-25