Home > Software engineering > Ask for help, in table 1 column in the database to make use of VB in a designated table after operat
Ask for help, in table 1 column in the database to make use of VB in a designated table after operat
Time：10-07
Great god teach me in the database is established in table 1, table 1 column a and b column, doing a * b * 0.7 * 30 results according to the order in table 1 in table 2, how to do ah, don't show up on the form,,,, how do you write for this code
CodePudding user response:
INSERT INTO table 2 SELECT a * b * 21 as [your column in the table 2] FROM table 1
