I have an application where i need to fill table column with data from another table.
Here an example:
I need to search in Table B using a non ID field (Column B) that is present in both table. In the end i have to copy Column C into Column A
How can i do it inside a trigger?