Thank you for the reply and the reformatting.

I was close then with this attempt before posting 🙂

update J

set J.JTypeID = Jtype.JTypeID

from jtype

inner join J on J.DID = D.DID

inner join D on D.CID = JType.CID

It was the SET line that was wrong but dont understand why exactly.

Tagged on "where JType.IsDefaultDeviceJState = 1" onto the end and we have a winner.

Thank you very much , great help.