Posted by Bob Stearns on 02/22/06 22:22

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.

[Back to original message]