Method, system, and program for performing a join operation on a multi column table and satellite tables

A system for performing a join operation on a multi-column table and at least two satellite tables having a join condition, comprising:

• a computer;
• a memory area accessible to the computer including at least one satellite table, wherein each satellite table is comprised of multiple rows and at least one join column and a multi-column table comprised of multiple rows and at least one column corresponding to the join column in each satellite table;
• and
• program logic executed by the computer, comprising:
• (i) means for performing a join operation on the rows of the satellite tables to generate a first join result comprising concatenated rows of the satellite tables;
• (ii) means for selecting less than all the concatenated rows in the first join result that satisfy the join condition;
• and
• (iii) means for joining the selected concatenated rows to the multi-column table.

An article of manufacture for use in programming a computer to perform a join operation on a multi-column table and at least two satellite tables having a join condition, wherein each satellite table is comprised of multiple rows and at least one join column and wherein the multi-column table is comprised of multiple rows and at least one column corresponding to the join column in each satellite table, the article of manufacture comprising computer useable media including at least one computer program embedded therein that is capable of causing the computer to perform:

• performing a join operation on the rows of the satellite tables to generate a first join result comprising concatenated rows of the satellite tables;
• selecting less than all the concatenated rows in the first join result that satisfy the join condition;
• and
• joining the selected concatenated rows to the multi-column table.