title: Update statement and Subquery
body: <p>I would like to use a Subquery to determine whether an update should be done on the OrderClosed status or not. But I can't seem to get this right.</p>
  
  <pre><code>Update Orders 
  set orderclosed = 1 
  where (
  SELECT dbo.orders.ordernr, 
     dbo.orders.orderdate, 
     dbo.orders.salesdate, 
     dbo.orders.deliverydate, 
     dbo.orders.orderclosed, 
     dbo.invoices.invoicenr 
  FROM   dbo.orders 
     LEFT OUTER JOIN dbo.invoices 
                  ON dbo.orders.id = dbo.invoices.orderid 
  WHERE  dbo.invoices.invoicenr IS NOT NULL 
     AND orderclosed = 0 )
  </code></pre>
  
  <p>Or am I thinking to simple?</p>