select/update query in same statement
Posted on 2015-01-13
Can anyone help me please,
I have a query where i do the select below, and now i need another query to update the same select fields based on the joining SO_Number...
FROM [PartDetail] pd
left JOIN [DataLink] ON [DataLink].Material = pd.Material
2nd query...(this is what i need to update everything above) so i would be supplying the query with params that match the fields in pd.