Query

• jagjitsingh

  Ten Centuries

  Points: 1059

  More actions

  November 12, 2017 at 6:00 am

  #340439

  Hi

  I have 1 Table with field Document Type . I want those records of Customer whose Sum(Amount) of Document Type 4 - Sum(Amount) of Docutype6 > 0

  then those records of that Customer whose Document Type in (4,6) should be displayed.

  Thanks

• Thom A

  SSC Guru

  Points: 99133

  More actions

  November 12, 2017 at 6:35 am

  #1967675

  You already posted this question some 2 hours ago here: https://www.sqlservercentral.com/Forums/1907347/Query

  Rather than posting a new topic, could you reply to Steve please? 🙂

  Thanks.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk