Table Joins

WinSQL Professional recognizes relationships that are specified on your back-end server using foreign key constraints. In addition to foreign keys, you can also create a local relationship among tables. For more information, see “Creating Local Relationships” later in this document.

When relationships are found among tables, the Intelli Tips window automatically displays the WHERE clause necessary for the JOIN statement, depicted as follows: