I'm not quite sure how to do this join:
Table1: Products
--------------------------
Prod_ID | Prod_Name | etc
Table2: Images
---------------------------
IMG_ID | Prod Name | Prod_ID |
Select Prod_ID, Count(i_Prod_ID) from tblImages right join tblProducts
on tblProducts.Prod_ID = tblImage.i_Prod_ID
Does not produce what I need.....
The desired end result is to produce a row for each product ID that contains the product ID and the number of images that product ID has
Desired Result:
------------------------------
Prod_ID | # of pic ids assigned to this product
1 | 5
2 | 6
3 | 0