title: Join SQL Query Problem?
body: <p>First Select Statement:</p>
  
  <pre><code>SELECT
  dbo.FG_FILLIN.PartNumber,
  dbo.DropshipPackinglist.Shiplist_Qty,
  dbo.DropshipPackinglist.Quantity
  FROM   dbo.FG_FILLIN INNER JOIN
         dbo.DropshipPackinglist ON 
         dbo.FG_FILLIN.PartNumber = dbo.DropshipPackinglist.PartNumber
  WHERE  (dbo.FG_FILLIN.Batch = 'CIP_HK_6')
  GROUP BY 
  dbo.FG_FILLIN.Batch,
  dbo.FG_FILLIN.PartNumber,
  dbo.FG_FILLIN.ItemNumber,
  dbo.DropshipPackinglist.Shiplist_Qty,
  dbo.DropshipPackinglist.Quantity
  </code></pre>
  
  <p>Result :</p>
  
  <pre><code>PartNumber  Shiplist_Qty    Quantity
  P02-070161-00111-C100   6   3
  P02-070161-10111-C100   6   3
  </code></pre>
  
  <hr>
  
  <p>2nd :</p>
  
  <pre><code>SELECT PartNumber,COUNT(Batch) AS Created
  FROM         dbo.FG_FILLIN
  WHERE Batch='CIP_HK_6'
  GROUP BY Batch,PartNumber
  </code></pre>
  
  <p>Result :</p>
  
  <pre><code>PartNumber  Created
  P02-070161-00111-C100   3
  P02-070161-10111-C100   1
  </code></pre>
  
  <p>Joining this two Query I cant show this one: RESULT NEEDED</p>
  
  <pre><code>PartNumber  Shiplist_Qty    Quantity  Created
  P02-070161-00111-C100   6   3            3
  P02-070161-10111-C100   6   3            1
  </code></pre>
  
  <p>It always show : when i Add <code>Count(dbo.FG_FILLIN.Batch) as Created</code></p>
  
  <pre><code>PartNumber  Shiplist_Qty    Quantity  Created
  P02-070161-00111-C100   6   3            6
  P02-070161-10111-C100   6   3            2
  </code></pre>
  
  <p>Any Advice.? Thanks In Regards!</p>