next up previous contents index
Next: Summary Up: Joining Tables Previous: Ordering Multiple Parts

   
Primary and Foreign Keys

 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.  


Bruce Momjian
2001-05-09