Table Lookup

[Dan]

I have a table named Product with a primary key called ProductID and an empty
column named NewColumn (along with several unrelated fields). I have a lookup
table with a column named ProductID and another column named NewColumn. I'm
trying to get the new data from the lookup table into the existing Product
table. Every time I come up with this situation, I'm thick as a brick and
I can't figure out how to do it.

Can anyone show me how to do this with a query? I'm currently doing it longhand
using a stored procedure that reads through the lookup table one row at a
time.

Thanks,

Dan

[Simon Sellick]

Dan,
Try:
UPDATE Table
SET NewCol =
SELECT NewCol
FROM LookupTable
WHERE LookupTable.ProductId = Table.ProductId

I think that's what you're after. I haven't tested it (server not available)
so apologies if the syntax is incorrect.
Hope this helps,
Simon.

"Dan" <dan.clem@trilogynetworks.com> wrote:
>
>I have a table named Product with a primary key called ProductID and an
empty
>column named NewColumn (along with several unrelated fields). I have a lookup
>table with a column named ProductID and another column named NewColumn.
I'm
>trying to get the new data from the lookup table into the existing Product
>table. Every time I come up with this situation, I'm thick as a brick and
>I can't figure out how to do it.
>
>Can anyone show me how to do this with a query? I'm currently doing it longhand
>using a stored procedure that reads through the lookup table one row at
a
>time.
>
>Thanks,
>
>Dan

[Dan]

I had to add parentheses around the SELECT statement, and then this worked
perfectly. Thanks much!

Dan

"Simon Sellick" <simon.sellick@tesco.net> wrote:
>
>Dan,
>Try:
> UPDATE Table
> SET NewCol =
> (SELECT NewCol
> FROM LookupTable
> WHERE LookupTable.ProductId = Table.ProductId)
>
>I think that's what you're after. I haven't tested it (server not available)
>so apologies if the syntax is incorrect.
>Hope this helps,
>Simon.
>
>"Dan" <dan.clem@trilogynetworks.com> wrote:
>>
>>I have a table named Product with a primary key called ProductID and an
>empty
>>column named NewColumn (along with several unrelated fields). I have a
lookup
>>table with a column named ProductID and another column named NewColumn.
>I'm
>>trying to get the new data from the lookup table into the existing Product
>>table.