Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
One to almost one
Message
From
22/01/1999 13:08:17
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00179045
Message ID:
00179075
Views:
24
>>>I have a clients table and a locations table. Each client has and address that is in the locations table. I want to join the clients table to the locations table so I can replace the address in the clients table with the key to that address in the locations table.
>>>
>>>For the most part, there is only one of each address in the locations table. But because I'm working with bad data, there might be more than one.
>>>
>>>Is there a join that will take one and only one of each client and match it up to the first address in locations that it finds, and doesn't make a second entry of the same client for the second address in locations?
>>>
>>
>>If you don't mind doing a two stage query.
>>
>>SELECT * FROM locations GROUP BY id INTO CURSOR locations2
>>SELECT clients.*, locations2.address FROM clients, locations WHERE clients.id = locations2.id INTO CURSOR clientloc
>>
>>ID is the unique key between the two tables.
>
>Sorry. There was a typo. I took out the duplicate "group by id"

It's still grabbing the wrong thing... I need to replace the client's address with the key of the location.

Thanks,

-Michelle
Previous
Reply
Map
View

Click here to load this message in the networking platform