Combining Tables

• To be useful, it is necessary to combine information from multiple tables

• This process is called join

Table1 JOIN Table2

ON FieldA = FieldB

means … for every

record in Table1 find

all records in Table2

that match, and make

a new record for the

resulting table

Table1

Table2

A

B

Previous slide

Back to first slide

View graphic version