|Liam Delahunty: Home||Tips||Web||Contact|
Think I deserve a present? See my Amazon Wish List
MySQL Left Outer Join
I want to see how many products don't have an image. The products are all in the product_tbl, and the images in the image_tbl. The image table caontains a column product_id.
This will give me a list off all the products that are in product_tbl but don't have an entry in image_tbl.