Update pos_Payment Pymt Set Pymt.Pymt_Sales_DateTime =(Select Sales_DateTime from Pos_Sales where Sales_Store = Pymt.Pymt_store and Sales_ctrno = Pymt.Pymt_ctrno and Sales_transno  = Pymt.Pymt_transno );
Update pos_Payment Pymt Set Pymt.Pymt_Sales_SuspendDate =(Select Sales_SuspendDate from Pos_Sales where Sales_Store = Pymt.Pymt_store and Sales_ctrno = Pymt.Pymt_ctrno and Sales_transno  = Pymt.Pymt_transno );
Update pos_Payment Pymt Set Pymt.Pymt_Sales_CustomerID =(Select Sales_CustomerID from Pos_Sales where Sales_Store = Pymt.Pymt_store and Sales_ctrno = Pymt.Pymt_ctrno and Sales_transno  = Pymt.Pymt_transno );
Update pos_Payment Pymt Set Pymt.Pymt_Sales_PriceLvl =(Select Sales_PriceLvl from Pos_Sales where Sales_Store = Pymt.Pymt_store and Sales_ctrno = Pymt.Pymt_ctrno and Sales_transno  = Pymt.Pymt_transno );