Support Linked Table In Custom View

Locked
Amer
User
Posts: 79

Support Linked Table In Custom View

Post by Amer »

It will be a great addition if we are able to use linked tables in custom views.

Linked table feature is great , it can bring a piece of data from outside your main database, but there are times when you need to mix this data with yours... the custom view is the only way here to mix two tables from different databases.

By mixing data from two or more tables I meant using a SELECT statement with INNER JOIN and ON.
The custom view offer this but only for tables from the main database.
There is no way currently to use SELECT queries with linked tables.


Webmaster
User
Posts: 9425

Post by Webmaster »

As explained in the help file Custom View is only a stored SELECT statement. Linked Table (table from other databases) can not be supported by Custom Views as they can NOT join tables from different databases.


Locked