<div>
Top shelf! &nbsp;Thank you!
</div>


<div>
Oh, ..the background....<br />
;-)<br />
<br />
This is called a Cartesian Product<br />
<br />
It is technically done by using a CROSS JOIN (Explicit)<br />
<br />
However Access does not support CROSS JOIN,(... I don't think...?)<br />
So I used the &quot;Implicit&quot; syntax above.<br />
<br />
You can do a search here or on the web for: &nbsp;Cartesian Cross Join<br />
<br />
;-)<br />
<br />
JeffCoachman
</div>


Oh, ..the background....
;-)

This is called a Cartesian Product

It is technically done by using a CROSS JOIN (Explicit)

However Access does not support CROSS JOIN,(... I don't think...?)
So I used the "Implicit" syntax above.

You can do a search here or on the web for:  Cartesian Cross Join

;-)

JeffCoachman

<div>
That's right! &nbsp;It makes sense after you mentioned the background information.<br />
<br />
Thank you sooooo much, Jeff. &nbsp;You da man.
</div>


That's right!  It makes sense after you mentioned the background information.

Thank you sooooo much, Jeff.  You da man.

<div>
<div class="content wysiwyg-content">
Greetings, Experts! &nbsp;I've been out of the loop with Access for quite a while and need your help with a small query project.<br />
<br />
I have two tables. &nbsp;I need to have a query that merges the values in a manner as shown below:<br />
<br />
TABLE 1:<br />
Dog<br />
Cat<br />
Human<br />
<br />
TABLE 2:<br />
1<br />
2<br />
3<br />
<br />
<br />
QUERY RESULTS: &nbsp;(single field)<br />
Dog 1<br />
Cat 1<br />
Human 1<br />
Dog 2<br />
Cat 2<br />
Human 2<br />
Dog 3<br />
Cat 3<br />
Human 3<br />
<br />
<br />
I know that this can be done, and can almost figure it out. &nbsp;Ol' Toddy is stumped. &nbsp;Help a poor guy out, purty please?<br />
<br />
I thank you kindly!<br />
<br />
<br />
Todd
</div>
</div>


Greetings, Experts!  I've been out of the loop with Access for quite a while and need your help with a small query project.

I have two tables.  I need to have a query that merges the values in a manner as shown below:

TABLE 1:
Dog
Cat
Human

TABLE 2:
1
2
3


QUERY RESULTS:  (single field)
Dog 1
Cat 1
Human 1
Dog 2
Cat 2
Human 2
Dog 3
Cat 3
Human 3


I know that this can be done, and can almost figure it out.  Ol' Toddy is stumped.  Help a poor guy out, purty please?

I thank you kindly!


Todd

Query That Uniquely Blends Values

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.