A join is performed by comparing two columns, like customer.customer_id and salesorder.customer_id. The customer.customer_id is called a primary key because it is the unique (primary) identifier for the customer table. The salesorder.customer_id is called a foreign key because it holds a key to another (foreign) table.