Hello,

I have 2 tables:

tableA
--------------
uniqueID int
typeID int

tableB
--------------
uniqueID int
date1 datetime
date2 datetime

I need to UPDATE tableB such that tableB.date2 is set to tableB.date1
where:

tableA.uniqueID = tableB.uniqueID
tableA.typeID = 5
tableB.date2 is null

Not all tableA records have a related record in table B.

Thanks in advance for any input,
chasse