title: Update SQL table with random value from other table
body: <p>On Microsoft SQL Server 2008, I have a table with Products:</p>
  
  <p><strong>Id | Name | DefaultImageId</strong></p>
  
  <p>And one with Images:</p>
  
  <p><strong>Id | ProductId | Bytes</strong></p>
  
  <p>I want to run an Update statement, that updates the DefaultImageId on all records in the Products table with a random Id from the Images table that is related to the Product via the ProductId column.</p>
  
  <p>Can anyone help out? Should be simple for any SQL Champ (Which is obviously not me)..</p>