Len,

Thanks, that's exactly what I was looking for. I spend so much time trying NOT to get this kind of result, I forgot how go get it when I need it.

Thanks again,

Rex

>>>All,
>>>
>>>I have two tables I wish to join. In this case the tables are not directly related, but could be through a third table. What I want is:
>>>
>>>Table 1
>>>1
>>>2
>>>
>>>
>>>The results of joining tables 1 and 2:
>>>
>>>11
>>>12
>>>13
>>>21
>>>22
>>>23
>>>
>>>Can this be done via SQL?
>>>
>>>TIA
>>>
>>>Rex
>>
>>
>>Sorry, lets try the example again:
>>
>>Table 1
>>1
>>2
>>
>>
>>Table 2
>>1
>>2
>>3
>>
>>The results of joining tables 1 and 2:
>>
>>11
>>12
>>13
>>21
>>22
>>23
>>
>>
>>TIA
>>
>>Rex
>if you want the result in separate fields, try
>
>select * from table1, table2