Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have 2 tables and i need the compare the country2 with the Country2 and if both are equal it should get corresponding Sub_Country
Country1:
| Sub_Country | Coutnry1 |
|---|---|
| US01 | US |
| Ind01 | Ind |
| Uk01 | UK |
| Ind02 | East Ind |
| Ind03 | West Ind |
Country2:
| Country2 |
|---|
| USA |
| INDIA |
| UK |
| INDIA |
Note: there is no common column exists
there is no way around it.
a computer can not (correctly) interpret data without a set of defining logic that provides context/instructions/rules for interpretation.
for example, it isn't feasible to suggest that there is a way to identify programmatically that the values "East Ind","West Ind", and "Ind" are all equivalent to the correlated field value "INDIA" without the use of a mapping/attribute table which defines the relationship.