I am doing some analysis from different databases. What I need to do is to see which ones of the records from DNI field, from the database CARTERA, exists in the field BENEF_DOC from the database PAGOS. For example, 38492213 and 37568943 exists in both tables. (In Cartera they are in the DNI field, and in Pagos they are in the BENEF_DOC field).
The idea is to create a new field in Cartera, that shows a number 1, if records from DNI exists in BENEF_DOC from Pagos. And a number 0 if they don't exist.
Thank you very much !! I would really appreciate if someone could help me with this.