Flynet DataConnect will automatically add Primary / Foreign Key relationships (joins) between tables as you add columns to your select statement for certain Full Experience databases.
This single-step joining will only be triggered in the following connection scenarios:
Using the Data Provider for .NET 4.0 only:
-
Microsoft SQL Server
-
Microsoft SQL Server Compact
-
Oracle
-
IBM DB2
-
Teradata
With every Full Experience database, you can create new joins using the tile-based drag and drop query builder. For all other databases, you create joins using SQL text in the normal way.