Update pos_SalesDtl dtl Set dtl.Sdtl_Sales_OperID = (Select Sales_OperID from Pos_Sales where Sales_Store = dtl.sdtl_store and Sales_ctrno = dtl.sdtl_ctrno and Sales_transno  = dtl.sdtl_transno ) ;
Update pos_SalesDtl dtl Set dtl.Sdtl_Sales_DateTime = (Select Sales_DateTime from Pos_Sales where Sales_Store = dtl.sdtl_store and Sales_ctrno = dtl.sdtl_ctrno and Sales_transno  = dtl.sdtl_transno );
Update pos_SalesDtl dtl Set dtl.Sdtl_Sales_RcptNo = (Select Sales_RcptNo from Pos_Sales where Sales_Store = dtl.sdtl_store and Sales_ctrno = dtl.sdtl_ctrno and Sales_transno  = dtl.sdtl_transno );
Update pos_SalesDtl dtl Set dtl.Sdtl_Sales_SuspendDate = (Select Sales_SuspendDate from Pos_Sales where Sales_Store = dtl.sdtl_store and Sales_ctrno = dtl.sdtl_ctrno and Sales_transno  = dtl.sdtl_transno );
Update pos_SalesDtl dtl Set dtl.Sdtl_Sales_Shift = (Select Sales_Shift from Pos_Sales where Sales_Store = dtl.sdtl_store and Sales_ctrno = dtl.sdtl_ctrno and Sales_transno  = dtl.sdtl_transno );
Update pos_SalesDtl dtl Set dtl.Sdtl_Sales_CustomerID = (Select Sales_CustomerID from Pos_Sales where Sales_Store = dtl.sdtl_store and Sales_ctrno = dtl.sdtl_ctrno and Sales_transno  = dtl.sdtl_transno );
Update pos_SalesDtl dtl Set dtl.Sdtl_Sales_PriceLvl = (Select Sales_PriceLvl from Pos_Sales where Sales_Store = dtl.sdtl_store and Sales_ctrno = dtl.sdtl_ctrno and Sales_transno  = dtl.sdtl_transno );