I have two databases. In each database I have an
employee table which differ from each other in the number of columns and column names.
Here is what the table looks in the first database:
Emp_ID Name Father_Name Family_Name 1 Max Stjepan Neg 2 John Chris James
Here is what the second table looks like which will be in the second database:
ID Name Father_Name Family_Name Blood_Type 1 Max Stjepan Neg ARH+ 2 John Chris James ORH-
Now when creating the foreign table in Second Database I want to store the
Emp_ID values from First Database with column name ID and also I want my foreign table to include the blood type from the table which is in the current database Second Database.
Shortly, how can I create a foreign table with different column names than the original table in remote database? It should also include the columns from first table which is in the current database.