EuSQL
- Posted by Alex Chamberlain <alex.chamberlain at tiscali.co.uk> Dec 07, 2005
- 573 views
I have 2 tables - CATEGORIES & PRODUCTS. Each product belongs to a Category and the category's ID is stored in Products as CAT_ID. How do I select the ID from Category and count how many Products contain that ID as a CAT_ID? Thanks, Alex
