Insert records from one table into another table with a loop!!!

#1 · May 16, 2022, 7:48 am

Hello and have a good time! Is it possible to use a loop command when calling a table! Insert its records with special conditions in another table! thanks all

#2 · May 16, 2022, 12:55 pm

@javadrajabihakami take a look here:

https://www.w3schools.com/sql/sql_insert_into_select.asp

Regards.

javadrajabihakami has reacted to this post.

#3 · May 17, 2022, 7:00 am

Quote from luishp on May 16, 2022, 12:55 pm

@javadrajabihakami take a look here:

https://www.w3schools.com/sql/sql_insert_into_select.asp

Regards.

Thanks for your response! Is there a way after loading the information in the subroutine! Can be used using the loop command! Or something else! Check each record and perform the relevant operation if it meets our requirements. I succeeded with the loop command after loading the information in the subroutine! Put them all in another table with the conditions I want! But the problem is that it only has to be done once! For example, once a year! It is difficult for me to check duplicate information! Thanks for the tip! Thanks

Insert records from one table into another table with a loop!!! - Forum

Insert records from one table into another table with a loop!!!