Insert multiple rows from another table

[andrewh]

I have three tables: Customers, Tasks and customers_tasks. The third table provides the relationship, so a customer can have multiple pre-defined tasks associated with it.

Consider the following:

Customers:
cust_1
cust_2

Tasks:
task_1
task_2

Now, when I create add record cust_3 to the Customer table, I also want to insert into the customer_tasks table a row for each of the tasks, eg:

customer_tasks:
Customer,Task
cust_3,task_1
cust_3,task_2

Is this possible?

[Marc_Dillon]

---

@andrewh wrote:

Is this possible?

---

Yep. Search for "add any number of rows" and/or "loop" in this community.

[andrewh]

Sorry, I'm not finding anything particularly appropriate. Please could you point me in the right direction?

[Marc_Dillon]

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Add-any-number-of-rows-from-any-row-within-a-tab...