title: Select Insert Statement returns 1000 fields instead of 10
body: <p>currently, I have this code in sql server that is supposed to get values from a database and put them into another database.</p>
  
  <pre><code>Insert into AppleFinalX.[dbo].SalesFactTable(SalesType, TotalSales, SalesHDRDate, ProductSales, ProductID) 
  SELECT AppleFinal.[dbo].SalesHDRTable.SalesType,
         AppleFinal.[dbo].SalesHDRTable.TotalSales,
         AppleFinal.[dbo].SalesHDRTable.SalesHDRDate,
         AppleFinal.[dbo].SalesDetailsTable.PurchaseAmount,
         AppleFinal.[dbo].ProductTable.ProductID
  FROM AppleFinal.[dbo].SalesHDRTable, 
       AppleFinal.[dbo].SalesDetailsTable, 
       AppleFinal.[dbo].ProductTable 
  </code></pre>
  
  <p>Basically, it gets values from three tables from a different database (AppleFinal), and puts them in a table in a different database (AppleFinalX). But unfortunately, it returns 1000 records instead of 10. Anyone know why this is happening? :( All tables have 10 records each so I was shocked to see 1000 records in the new table...</p>