use foreach or single query? (Counting Inventory)

use foreach or single query? (Counting Inventory)

El Forum
Guest

01-22-2010, 07:35 AM

[eluser]Unknown[/eluser]
Try this:

Code:
SELECT

  inv.product_id,

  COUNT(*) AS product_quantity,

  prd.part_number,

  prd.description,

FROM inventory AS inv

JOIN products AS prd

ON prd.product_id = inv.product_id

GROUP BY inv.product_id

Messages In This Thread

use foreach or single query? (Counting Inventory) - by El Forum - 01-22-2010, 07:21 AM

use foreach or single query? (Counting Inventory) - by El Forum - 01-22-2010, 07:35 AM

use foreach or single query? (Counting Inventory) - by El Forum - 01-22-2010, 07:49 AM

use foreach or single query? (Counting Inventory) - by El Forum - 01-22-2010, 09:05 AM

use foreach or single query? (Counting Inventory) - by El Forum - 01-22-2010, 09:29 AM

use foreach or single query? (Counting Inventory) - by El Forum - 01-22-2010, 10:24 AM

use foreach or single query? (Counting Inventory) - by El Forum - 01-22-2010, 11:07 AM

use foreach or single query? (Counting Inventory) - by El Forum - 01-22-2010, 12:20 PM

use foreach or single query? (Counting Inventory) - by El Forum - 01-22-2010, 01:54 PM

use foreach or single query? (Counting Inventory) - by El Forum - 01-22-2010, 02:02 PM

use foreach or single query? (Counting Inventory) - by El Forum - 01-22-2010, 03:43 PM

use foreach or single query? (Counting Inventory) - by El Forum - 01-22-2010, 04:05 PM

use foreach or single query? (Counting Inventory) - by El Forum - 01-22-2010, 04:43 PM

use foreach or single query? (Counting Inventory) - by El Forum - 01-22-2010, 04:46 PM

use foreach or single query? (Counting Inventory) - by El Forum - 01-22-2010, 08:21 PM