Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hallo Everyone,
i need your help pleace. I have 2 tables ZIP and Customers and i want to join the boht tables , but these do not have the same key. How can I get a key in table 'ZIP', so that they can access to Custumer?
ZIP( This table contains the coordinates of all the countries in the world)
Country | City | Latitude | Longitude |
---|---|---|---|
Customers
Customers | City |
---|---|
Thanks In advance
William
Is City not the same column in both tables?
- Marcus
Hi,
You have city column.
Join it on City column.
Regards
no this is not the same column.
Without a matching-field you won't be able to match these tables in a way which makes sense. Maybe you need to adjust one or both of these fields or join them before with other datas which make you able to generate such key-field.
Where are the differences between both city-fields?
- Marcus
Hey Marcus the Problem was resolved. I have the column 'Country' in the Customer table to excel exported and a new column 'Country_Code' generated in Excel and then a key between the ZIP table and the Customer table by mapping constructed
William