Combine all Account Names with All products (2 Tables)

[lynchjl7748]

I have two tables one with a list of accounts and what products they have and a second with a list of products. I want to create a list of all account names and all products, so Column 1 would be the account name and column 2 would be the product name. So in theory I would get a table with about 200 products per account name. I know I have done this in the past but for what ever reason I can't solve it now. Any help is greatly appreciated.



Thanks,
Jeff

[davegri]

Why is this not already what you want?

one with a list of accounts and what products they have

[lynchjl7748]

Why is this not already what you want?

I need a list of all the accounts and all potential products that an account could have.

[pbaldy]

A query including the accounts table and the products table without a join will return all possible combinations (a Cartesean product).

[lynchjl7748]

A query including the accounts table and the products table without a join will return all possible combinations (a Cartesean product).

Thank you!!!

[pbaldy]

Happy to help and welcome to the site by the way!