|
|
Posted by Bob Stearns on 02/23/06 03:54
strawberry wrote:
> "Bob Stearns" <rstearns1241@charter.net> wrote in message
> news:%H3Lf.978$BS6.341@fe04.lga...
>
>>strawberry wrote:
>>
>>>old table has place names, say a to z.
>>>
>>>new table has to list all posssible connections, ie, a-b ,a-c , b -a .
>>>
>>>can anyone point me in the right direction for how to do this?
>>>
>>>tia.
>>
>>insert into links
>> (select from.name, from.lat, from.lon, to.name, to.lat, to.lon
>> from orig_table from
>> join orig_table to on from.name<>to.name)
>>
>>should be close to what you want.
>
>
> so that links all names that aren't the same?
>
>
Yes. That was what I red the specs as meaning.
Navigation:
[Reply to this message]
|