Sub-Queries

When adding an existing DBxtra Report Object to the Query, the Sub-Query will be displayed in another Query Builder tab.

Linked / Unlinked Sub-Query

By default a Sub-Query is linked to the original Report Object’s underlying Query.

That means if you edit the original Query, its changes will be reflected at all Queries which use it.

Edit Sub-Query

If you change the structure of the Sub-Query it will become unlinked .

Note! When a Sub-Query becomes unlinked and the original Query changes it will not inherit those changes.