Add column from another table

[David Scott]

I would like to add a column to a table where the column to be added is in 
another table. The column entries are to be matched using a particular 
column from each table.

I have one table detailing phone calls, indexed by CallID. I have 
created another table with the same index and a column CallNumber which I 
want to add to the phone call table.

I have looked at documentation and in the book I have available without 
success. Can anyone suggest appropriate syntax for this?

David Scot

_________________________________________________________________
David Scott	Department of Statistics, Tamaki Campus
 		The University of Auckland, PB 92019
 		Auckland 1142,    NEW ZEALAND
Phone: [phone] ext 86830		Fax: [phone]
Email:	d.scott@stripped

Graduate Officer, Department of Statistics
Director of Consulting, Department of Statistics