Posted by Guy on 02/23/06 10:40

strawberry a écrit :
> the columns are
>
> location, longitude, latitude,
>
> i want to makeinto
> location a, location b.
>
> where each location is mapped to each other ie, point a has conenctions to
> b -z, b has connections to a, and c-z.
>

Bonjour,

select
tb1.location,tb2.location,tb1.longitude,tb1.latitude,tb2.longitude,tb2.latitude
from table_location tb1,table_location tb2
where tb1.location <> tb2.location ;

<> => Not equal

GR

> "Simon" <simon@webworx.co.uk> wrote in message
> news:M91Lf.69546$0N1.44349@newsfe5-win.ntli.net...
>
>>can you be more specific?
>>
>>What are your columns what do you want to copy and to where..
>>
>>
>>
>>"strawberry" <1@2.com> wrote in message
>>news:vjZKf.11778$bw1.10372@newsfe2-win.ntli.net...
>>
>>>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.
>>>
>>>
>>
>>
>
>

• Next in forum: Re: How do I get MySQL commands to work in PHP?
• Prev in forum: Re: Form with picklist
• Thread view: Re: want to create table from old table

[Reply to this message]