A huge big thanks Ade,

That's the query, worked a treat after I added a WHERE clause outside the brackets

Adrian Nichols (9/22/2008)

Something like this should work for you:

UPDATE asset_table

SET locationID =...

A big thanks Ade,

Actually, looking at it, it does update the virtual computers. In fact it updates all rows which fixes the virtual computers but destroy the location id's of...

Thanks for the quick response Ade,

I've typed it exactly as you presented but it just updates the hosts location_ID to it's own virtual host, which is null as it doesn't...