Posted by strawberry on 02/23/06 13:00

"Bob Stearns" <rstearns1241@charter.net> wrote in message
news:Tz8Lf.123$3%4.95@fe02.lga...
> 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.

exactly what i wanted! , many thanks, shall implement this afternoon.

[Back to original message]