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