I have a table named FINCAS that contains 2 fields named:
CODPOS and CODPOSP that store the zip-code of a house and the zip-code of the owner of the house.
This values are often distinct.
In my report, I show the information of FINCAS and I have to put the name of the country associated to CODPOS and CODPOSP.
The names of the countries are in a table named PROVIN whith two fields: CEPROVIN and DEPROVIN
CEPROVIN contains the two first digits of the zip-code.
So I have to query PROVIN table 2 times, the first with the two first digits of CODPOS and the second with the two first digits of CODPOSP.
What is the way to do this?
Thank you.
CODPOS and CODPOSP that store the zip-code of a house and the zip-code of the owner of the house.
This values are often distinct.
In my report, I show the information of FINCAS and I have to put the name of the country associated to CODPOS and CODPOSP.
The names of the countries are in a table named PROVIN whith two fields: CEPROVIN and DEPROVIN
CEPROVIN contains the two first digits of the zip-code.
So I have to query PROVIN table 2 times, the first with the two first digits of CODPOS and the second with the two first digits of CODPOSP.
What is the way to do this?
Thank you.