Say you have the following 2 tables:

table1: books
col1: unique_id
col2: title
col3: author
col4: sales

table2: sales
col1: unique_id
col2: author
col3: total sales:

here's some sample data:

books:
1,book1,mr smith, 100
2,book2,mrs jones, 20

sales:
1,mr smith, NULL
2,mrs jones, 19

i want to put the `sales` value from the first record in books into the `total tales` column in the first record in sales.

I just can't get it to happen. I've tried a number of approaches. I'm using Sql Server 2000.