CREATE TABLE [dbo].[J]([JID] [int],[JTypeID] [int],[DID] [int])

CREATE TABLE [dbo].[JType]([JTypeID] [int],[CID] [int],[IsDefaultDeviceJState] [bit])

CREATE TABLE [dbo].[D]([CID] [int],[DID] [int])

INSERT INTO J VALUES (1,NULL,1),(2,NULL,2),(3,NULL,1)

INSERT INTO JType VALUES (1,1,1),(2,1,0),(3,1,0),(4,2,0),(5,2,0),(6,2,1)

INSERT INTO D VALUES (1,1),(2,2)

UPDATE J

SET JTypeID = JType.JTypeID

FROM

J

INNER JOIN

D

ON

J.DID = D.DID

INNER JOIN

JType

ON

D.CID = JType.CID

SELECT * FROM J