The "full table names" like db1.t1 are allowed in some special cases like joins.

For example:

select a.f1, b.f1 from Db_Join_1.t1 a, Db_Join_2.t1 b WHERE a.id = b.ptr

Joins, unions allow fully qualified table names from different db, but it works with some restrictions. The only traditional relations (by value) is possible to build a join result. So, neither ObjectPtr nor binary links can be used in such context.

Sure, both dbs must be registered and opened.

Hi Ivan, thanks for the tip. I see that you have added explanations to the UNION, INTERSECT and EXCEPT
page on the WIKI.

There is also no NOTIFY CHANNEL, [UN]SUBSCRIBE commands in the SQL section.
Your team is working to expand the capabilities of the VDB engine, but it will be difficult for a new user to find them, if they are not described in the appropriate sections of WIKI.
Not everyone will study announcements of all releases to find out all VDB feautures.

Hi Vladimir,

Thank you for that - fixed.

(Un)Subscribe

Notify

OK, tx