SQL Query (displaying fields)

I need to display what a customers total purchases (Purchases) were on a specific product and what their total purchases (Total Purchased) were overall. These two columns come from the same table and should be displyed in the same query result.

This is to view what percentage of money is spent on a particular product as opposed to other products.

If possible just provide me with the syntax and I can fill in the appropriate fields.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!