OpenOffice Calc Join Table Based On Common Column

Combine two OpenOffice Calc tables into one based on a common column of data from each table. Rows from the two unequal tables will line up perfectly without copying and pasting. Calc 2.0 or higher required.