Table 1: the user number, user ID, user name
Table 2: the user ID, user amount, top-up date
I had a query,
Select t1. The user needs, the t1. The user name, t2. User amount, t2. Top-up date from t1, t2 where t1. The user ID=t2. User ID
Query to get the desired results, but need to result in t2. The user amount is modified, only to find records cannot edit, consult everybody how to solve?
CodePudding user response:
What is called "on the result of t2. Modify the user amount"? Are you using now is not inline a select statement? Modify the t2. User amount is not need to use the update statement for table 2 operate?