i have a small app that reads a forecourt program's database. i want to get the current shift's info from that and display/print it out.
SELECT name, liters, amount FROM salemast ORDER BY name
the above statement was my first idea, but that didn't add them. just got a long list of all sales in alphabetical order. pft.
SELECT name, SUM(liters), SUM(amount) FROM salemast ORDER BY name
the next statement just gave me one name and a total of all the sales. pft again.
what tiny little statement am i missing out here?