I think I explained very detailed what I need in one of my posts.
Please check and let me know if anything missing in my second explanation:
First, db1 has:
SELECT ObjectID, Media, artist, place, gender from db1.view1
Example:
1, paint, Arthur, Europe, male;
2, paint, John, US, male;
3, wood, Ann, Europe, female;
Second, db2 has:
SELECT CustomData.Field_ID, CustomData.Record_ID, FieldDef.Name, CustomData.StringValue
FROM CustomData LEFT JOIN
FieldDef ON FieldDef.Field_ID = CustomData.Field_ID
Example for CustomData table (Field_ID, Record_ID, StringValue):
10, 18031, 1
10141, 18031, Arthur
Example for FieldDef table (Field_ID, Name):
10, ObjectID
10140, Media
10141, artist
10142, place
10222, gender
What I need to check: If Object_ID = 1 (or any other Object_ID which is in db1.view) exists in CustomData.
If yes, then INSERT/UPDATE CustomData table to have:
10, 18031, 1
10140, 18031, paint
10141, 18031, Arthur
10142, 18031, Europe
10222, 18031, male