You can achieve it in a following manner:
<br />
<br />
UPDATE L2<br />
SET L2.AreaID = S2.AreaID, <br />
L2.Category = L3.Category<br />
FROM Line2 L2<br />
INNER JOIN Sheet2 S2 ON L2.gateID = S2.gateID<br />
INNER JOIN Line3 L3 ON L3.gateID = S2.gateID<br />
<br />
Please let me know if you think that I am not understanding the question properly.
-Nayan
Coding is an earthly heaven