Posted by strawberry on 02/23/06 01:57

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

[Back to original message]