Forums

The forums ran from 2008-2020 and are now closed and viewable here as an archive.

Home › Forums › Other › [Sql] subquery insurance

  • This topic is empty.
Viewing 1 post (of 1 total)
  • Author
    Posts
  • October 20, 2011 at 5:08 am #34837
    eXo
    Member

    I have 2 tables

    Table: Damage

    DamageNumber
    DamageAmount
    PolisNumber

    Table: Polis

    PolisNumber
    OwnRisk

    Desired result

    An overview that is sorted by the PolisNumber and with the total Premium( Premium = DamageAmount >= OwnRisk) for that PolisNumber and OwnRisk( OwnRisk = DamageAmount < OwnRisk) for that Polisnumber.

  • Author
    Posts
Viewing 1 post (of 1 total)
  • The forum ‘Other’ is closed to new topics and replies.