I explain. I have a table called OBS_SITEDS that works as a history table of all obervations that are entered, this table has the following fields: code, date, observation And I have the other table that is called CRED_CTACTE where I need the last record of the observation field entered in the table OBS_SITEDS is shown in this table (CRED_CTACTE), this table has the following fields id_ctacte, date, observation, nro_ctacte.
The two tables are joined by the id_ctacte. In the table OBS_SITEDS the code field is the id_ctacte of this table.
I'm using ORACLE.
Someone who can help me.
Thank you.