I have a view in Oracle with customer data from e.g. table DEBTABLENL:

```
SELECT DEBTABLENL.ACCOUNTNUMBER  AS DBDebnmbr
 , DEBTABLENL.ELCSEARCHCODE   AS DBNameShort
 , DEBTABLENL.NAME    AS DBName1
 , Etc, Etc FROM DEBTABLENL

```

Is it possible to extend the view to include the same kind of records from a different table, in this example DEBTABLEBE

```
SELECT DEBTABLEBE.ACCOUNTNUMBER  AS DBDebnmbr
 , DEBTABLEBE.ELCSEARCHCODE   AS DBNameShort
 , DEBTABLEBE.NAME    AS DBName1
 , Etc, Etc FROM DEBTABLEBE

```

Thus ending up with one view with all my customers from NL and BE. 
My BE customers are in a MSSQL database which I'll transfer daily to my Oracle database to get one big list.
Because the Oracle View has to have the records I can't go the other way around..

Regards,

Mike