Patent ID: 6640221
Filing Date: 2003-10-28
Classification: G06F,Y10S

Abstract:
A system for configuring, sequencing and displaying joins in a query, comprising:a sequence display window for depicting the sequence in which a plurality of tables are joined in the query, and for selecting an intermediate result set comprising two or more of the depicted tables; and a join configuration and display window for displaying the selected intermediate result set, including a table display for depicting the tables associated with the intermediate result set, a join type selector for configuring the type of join for the intermediate result set, and a relationships display window for depicting one or more relationships between the tables in the intermediate result set; wherein the join type selector selects from a list of join types, wherein the list of join types comprises an inner join type and an outer join type; wherein the tables include columns, wherein the columns of two different tables are capable of having a join relationship between the columns; wherein the join type selector configures a join type two of the tables independently of a join relationship involving the tables' columns.