Create query that copies fields X number of times from both tables?

[natasha_l]

I imported two excel files to Access. One file has a list of product numbers (no duplicates), one file has a list of organization codes (no duplicates). I want to create a query that extracts the fields from my two new tables, so that each product number is then listed next to one organization code.


e.g.
1111 AAA
1111 BBB
1111 CCC
2222 AAA
2222 BBB
2222 CCC

Can I create a sql query for this in Access? I've played around with Access a bit, but I'm stuck. Basically I need to copy/insert fields. I know basic sql syntax, but I've only ever written my own statements from scratch when extracting raw data from one table. Should I combine the two lists into one table first? I thought I could do this with VBA in Excel, but I got stuck quickly, and someone mentioned that Access can easily perform this task.
Thanks for any advice.

[aytee111]

Here is a query that will do that:

SELECT Table11.Product, Table12.Organization
FROM Table11, Table12;

This takes all of the products and all of the organizations and creates records. Both tables will be duplicated in this query so that the number of records that result from this will be count of table 11 plus count of table 12.

(In case you don't know what to do, go to Create > Query Design > SQL View, then copy and paste this changing the names as applicable)