User Profile

Collapse

Profile Sidebar

Collapse
kalindi05
kalindi05
Last Activity: May 12 '06, 05:21 PM
Joined: May 8 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • kalindi05
    replied to Complex Update query
    in General
    It worked!! Thank you so much....
    See more | Go to post

      Leave a comment:

    • kalindi05
      started a topic Complex update query
      in Oracle

      Complex update query

      Hello everyone,

      Please help me revise this query to make it work. I don't know much about update query so I will need some help with it. Thanks,


      update encounter
      set mergedpayment = totalactualcash payments
      from encounter E, paymentITEM P, encounterfinanc ialrecord F
      where (E.encounterid = P.FINANCIALRECN UM) AND (E.encounterid = F.FINANCIALRECN UM) and (transtypecode = 'C') and (F.INSPLANCODE...
      See more | Go to post
      • kalindi05
        started a topic Complex Update query
        in General

        Complex Update query

        Hello everyone,

        Please help me revise this query to make it work. I don't know much about update query so I will need some help with it. Thanks,


        update encounter
        set mergedpayment = totalactualcash payments
        from encounter E, paymentITEM P, encounterfinanc ialrecord F
        where (E.encounterid = P.FINANCIALRECN UM) AND (E.encounterid = F.FINANCIALRECN UM) and (transtypecode ...
        See more | Go to post
        No activity results to display
        Show More
        Working...