How do I build this sql statement?

[developing]

I need to populate a table with customer and produdct number so that a new table will have products A-C for each customer 1-9

so
customer product
1 A
1 B
1 C
2 A
2 B
2 C

and so on...i think this can be doine with sql statements, but i have no idea how...any help is highly appreciated...thanks

[MMcCarthy]

I need to populate a table with customer and produdct number so that a new table will have products A-C for each customer 1-9

so
customer product
1 A
1 B
1 C
2 A
2 B
2 C

and so on...i think this can be doine with sql statements, but i have no idea how...any help is highly appreciated...thanks

Try a full outer join as follows:

SELECT customerID, productID
FROM customers, products
ORDER BY customerID;
 

Mary

[developing]

oh wow, talk about forgetting the basics...thanks lol

[MMcCarthy]

oh wow, talk about forgetting the basics...thanks lol

No problem ;)