Combine two unrelated tables into 1

[David]

Hello,
I have two tables that are not related and would like to combine them into
one table (Table 3 below).

Table1:
Text Field1: Group
Records: 150

Sample:
Record1:Group1
Record2:Group2
Record3:Group3


Table2:
Text Field2: Type Description
Text Field3: Sub Type Description
Records: 50

Sample:
Record1: Type1, SubType1
Record2: Type2, SubType2

DESIRED results, each record in Table1 will have 50 values from Table2.
Table3:
Text Field1:
Text Field2:
Text Field3:
Records: 7500

Record1:Group1, Type1,SubType1
Record2:Group1, Type2, SubType2
Record3:Group2, Type1, SubType1
Record4:Group2, Type2, SubType2

Any thoughts about how to accomplish this?

 

[Jeff Boyce]

David

You've described a "how", but not "why"...

I assume you don't want to create a new (combined) table solely to have a
new combined table, but because you intend to do something with it.

If you'll describe more about what (and why) you are trying to do, the folks
in the newsgroup may be able to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Spencer]

Put both tables into a query with no join. That should be all you need for
your solution

The SQL statement might look like:

SELECT *
FROM Table1, Table2

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[David]

Thank you John.\

Put both tables into a query with no join. That should be all you need for
your solution

The SQL statement might look like:

SELECT *
FROM Table1, Table2

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..