So the situation is as follow:
I have production DB called DB1 which has huge data, around 250 GB. I have Test DB called DB2 on my local machine which has the same schema as the production DB but only the first two tables are partially filled(UUT_RESULT, STEP_RESULT).
What I want: Copy the only related data from the Production DB tables (PROP_RESULT) to my local DB table.
Very important note: I can copy the entire table, However, it's huge. That's why I only want to copy the data from PROP_RESULT table in the production DB which has relation to the already existed data in my local DB.
Note: Only UUT_RESULT and STEP_RESULT are partially filled in the Local DB, other tables are empty and I need to populate them and that's why I am posting this.
The following image will make is easier to understand