USE IT |
| Arvind Kumar replied to Epifanio Pineda Guadarrama at 03-Jul-08 11:40 |
SELECT SUM(sales), S.*, I.*, D.* FROM 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 |
|