[RESOLVED] sql server 2000 - help with insert from one table to another

[MMock]

ah... I've just remembered that you can't use an alias for the table to Update!

ah...now I understand!

Awesome - with a little bit of tweaking the query worked. I got a subquery returned more than one value error (I was kind of expecting it, actually) and I also realized I was probably updating to null instead of updating the nulls to non-null, so this was the end result:

update ldc_zip
set ldc_zip.ldc_ik = (select top 1 ldc_ik
                      from ldc_zip t2 
                      where ldc_zip.zip = t2.zip and t2.ldc_ik is not null)
where ldc_zip.ldc_ik is null

Thanks very, very much!