Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement