Combine two unrelated tables into 1

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David - 09 Nov 2007 18:12 GMT

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?

Reply to this Message

Jeff Boyce - 09 Nov 2007 19:22 GMT

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

> Hello,
> I have two tables that are not related and would like to combine them into
[quoted text clipped - 31 lines]
>
> Any thoughts about how to accomplish this?

Reply to this Message

John Spencer - 09 Nov 2007 19:22 GMT

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

Signature

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

> Hello,
> I have two tables that are not related and would like to combine them into
[quoted text clipped - 31 lines]
>
> Any thoughts about how to accomplish this?

Reply to this Message

David - 09 Nov 2007 22:24 GMT

Thank you John.\

> Put both tables into a query with no join. That should be all you need for
> your solution
[quoted text clipped - 39 lines]
> >
> > Any thoughts about how to accomplish this?

Reply to this Message