Updating Webshop Datatbase

Hello all,

I'm working on webshop database consisting of these tables:
customers, customers_groups, products_groups, products
For every customer (in customers) there is an entry in customers_groups.
The price lists that are used for every customer are defined in the table products_groups.
In products_groups the ids of customers_groups and products are used to assign a special price to every group.

Now I would like to insert data from another db on the sqlserver that holds the customer and product information.
So I have to insert price entries for all products for each customer.
I working on some t-sql procedures that should do that job.

In pseudo code:



Code SnippetFOR EACH customer
FOR EACH product
INSERT INTO products_groups (, ...price)
END FOR
END FOR






Would that be a cross join?


Thanks in advance for every hint!