With DBxtra creating Queries is really very easy.
You can create Queries from database objects like tables and views and also from exiting DBxtra objects like DBxtra Queries and DBxtra Reports.
You can also create Queries by mixing database objects with DBxtra objects.

DBxtra allows you to work on several objects at the same time.
Each time you load an existing object or create a new one an object tab will be accessible.

You can see the Object path and the Data Connection.

Important!
When working with heavy queries and sub-queries, synchronization between
panes might slow down . Therefore it is recommended
to turn the SQL pane of.
To turn the SQL pane off, select "View" and "SQL Pane" on the menu bar.
When you open a Query you will also see each underlying Query of it.
If you change an underlying Query from these tabs it will only affect the Main Query you are working on.
The underlying Query object itself will not be affected.

Note! If you make changes to the underlying Queries then those changes will be reflected in the Query based on the underlying Query.
Important! If you edit the underlying Query directly from inside the underlying Query tab then the Query object will not be affected; only the main Query.

In this case your Main Queries underlying Query will be disconnected.
DBxtra .NET allows full synchronization between Diagram, Grid and SQL Panes.
Once you change any setting in either Pane all other Panes will be synchronized automatically.
You can also write an SQL syntax manually or paste an existing SQL code and the Diagram and Grid Pane will synchronize.
Movies
Related