1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

Combine data from two rows into one

Discussion in 'Databases' started by lektrikpuke, Mar 31, 2016.

  1. #1
    When I do a query, I get the following results (see attached image). I would like the January rows to be combined into one row, and the same for March. I cannot seem to get the desired results (in one query - without using a temporary table). I've done a bit of research, and can't find anything useful. Any help?
     

    Attached Files:

    lektrikpuke, Mar 31, 2016 IP
  2. lektrikpuke

    lektrikpuke Well-Known Member

    Messages:
    297
    Likes Received:
    1
    Best Answers:
    1
    Trophy Points:
    113
    #2
    Solved! =) A friend of mine suggested http://www.artfulsoftware.com/infotree/qrytip.php?id=523 It seems I needed to move sum from the field itself and place it around the case statement.
     
    lektrikpuke, Apr 1, 2016 IP