Jump to content

Henry Olive

Members
 View Profile  See their activity

  • Content Count

    330

  • Joined

  • Last visited

Everything posted by Henry Olive

  1. Henry Olive

    SQL Update

    Henry Olive posted a topic in Databases

    I wish everyone a healthy day I'm getting multiple rows in singleton select err.msg. UPDATE ORDERS O SET O.DELVTOTAL= (SELECT(OD.QTY - OD.REMQTY) * OD.UPRICE FROM ORDETAIL OD WHERE O.ID=OD.ID) WHERE EXISTS (SELECT 1 FROM ORDETAIL OD WHERE O.ID = OD.ID AND O.STATUS='Partial Delivery') what is wrong ? Thank You
  2. Henry Olive

    SQL Update

    Henry Olive replied to Henry Olive's topic in Databases

    Yes, Thank so much Attila
×