Member Avatar for cinnamonsui

Anyone want to help me with this SQL-code? http://pastebin.com/VWnJmM34
I want to add a column that shows the number of cupcakes the customer bought for that specific order_date. Is this possible? How do I do it?

  • 3 Contributors
  • 2 Replies
  • 64 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for tinymark

Is there more than one order per day? Do you have a flat or relational design?

Member Avatar for debasisdas

I want to add a column that shows the number of cupcakes the customer bought for that specific order_date

I assume you are trying to add that column in SQL output, not in the actual table.

Kindly post your table structure and relation between them.

Edited by debasisdas because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.