SQL to sum items in table for each ID in master table

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • pankajnaagar
    New Member
    • Sep 2007
    • 1
    #1

    SQL to sum items in table for each ID in master table

    SQL statement with two table one is master and other is transaction and want to get itemname from master table and sum of other field from transaction table.
    Tags: None
    • debasisdas
      Recognized Expert Expert
      • Dec 2006
      • 8119
      #2
      Try to implement that logic by SQL queries at the back end.

        Comment

        • Killer42
          Recognized Expert Expert
          • Oct 2006
          • 8429
          #3
          Originally posted by debasisdas
          Try to implement that logic by SQL queries at the back end.
          Yes, and any time you have questions about SQL, I'd recommend asking them in the Access forum. There are lots of SQL experts over there.

            Comment

            Previous template Next
            Working...