>>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