how to join update & join in dts query designer??

[rpet]

hello all! <br><br>i don't know how to get this update statement in sqlserver7<br>running. i guess it's a syntax problem... <br><br>table A (field1 Id, field2 Data,...)<br>table B (field1 Id, field2 Data)<br><br>B is a &quot;temporary&quot; table that has a corresponding &quot;Data&quot;<br>for each Id. in table A this field is empty:<br><br>A.Id ¦ A.Data&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;B.Id ¦ B.Data<br>-------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;----------------<br>1&nbsp;&nbsp;&nbsp;&nbsp;¦ NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;¦ Value1<br>2&nbsp;&nbsp;&nbsp;&nbsp;¦ NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2&nbsp;&nbsp;¦ Value2<br>3&nbsp;&nbsp;&nbsp;&nbsp;¦ NULL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3&nbsp;&nbsp;¦ Value3<br><br>now i want to copy B.Data to A.Data which looks very simple<br>but... i could not find the correct update-syntax. how do i<br>&quot;join&quot; an update and a join?<br><br>any help would be greatly appreciated! TIA<br><br>--ralf<br>

 

[rpet]

solved. i checked the msdn for the _correct_ update syntax.<br><br>thank you anyway!

 

[MikeLacey]

Hi rpet,<br><br>Would you mind posting the solution?<br> <p>Mike<br><a href=mailto:michael.j.lacey@ntlworld.com>michael.j.lacey@ntlworld.com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>