Is this possible? Update Sub Query Question 1

[baddos]

I have two tables...

customer
custid int 'Primary Key
custshipper int

items
itemid int 'Primary Key
custid int 'Foreign Key
itemshipper int


I want to update the items table to put each customers shipper into the items table for their items.

 

[Idokyoku2]

I belive you're looking for this:

Update Items
set itemshipper = b.custshipper
from Items a inner join customer b
on a.custid=b.custid

Be sure to BACKUP before conducting any updates as a rule of thumb. Found that out the hard way!

-David