title: SQL UNION INNER JOIN
body: <p>Im trying to select from 2 tables that have the same columns, but both tables have an inner join - </p>
  
  <pre><code>select e.ID, 
      c.FullName, 
      car.VIN, 
      car.Registration, 
      e.Telephone, 
      e.Mobile, 
      e.Email, 
      e.EstimateTotal, 
      e.LastUpdated, 
      e.LastUpdateBy from (select id from Estimates UNION ALL select id from PrivateEstimates) e
  
  inner join Customers c on c.ID = e.CustomerID
  inner join Cars car on car.ID = e.CarID
  where e.Status = 0
  </code></pre>
  
  <p>The trouble is, it can't find e.CustomerID, e.CarID or e.Status on the inner join? Any ideas?</p>