hope you want query like this! |
| sundar k replied to Epifanio Pineda Guadarrama at 03-Jul-08 01:16 |
select
sum(sales), i.item
sales s,
detailsales d,
items i
where
s.sale = d.sale
and d.item = i.item
and d.date = <<your date>>
and i.line = <<your specific line>>
group by i.item |
|