Have any questions? Email: info@flynet.email. US: +1 617-778-7259. UK: +44 (0)3333-110-370. ES/PT: +351-300-500-441.

Auto Joins

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.