Hierarchical Query (Parent Child Query) Generation

One of the most compelling features of SQL Sets is the ability to easily generate hierarchical queries to retrieve related data in a parent child tree. We call this feature a Deep Fetch Query. The hierarchical query is generated based on the foreign key relationships defined in the SQL Server database. When generating the query, SQL Sets will recursively "follow" the relationships from the Parent/Root table down through all if its children and their children's children......until it gets to the bottom of the tree.

The result of this parent child sql generation is a query that can be used to pull back ALL data for a given parent table row(s) and ALL data from related children. This can go 5, 10, 100 or more tables deep. With these recursive joins you can easily capture a snapshot of ALL data for a particular Customer, Product, Order or similar. This SQL Server data snapshot can then be saved as a Portable Data Document and shared with business partners or co-workers. For a more in-depth look at the Deep Fetch Query, check out the Feature in Focus blog entry. Check out other SQL Set Features or other SQL Set Uses.

The Relationship Navigator allows you to easily move from table to table in the hierarchy.

Each table in the relationship hierarchy is displayed in its own tab.