Re: EuSQL
- Posted by Alex Chamberlain <alex.chamberlain at tiscali.co.uk> Dec 08, 2005
- 555 views
I'm not sure if this is a problem with EuSQL? I have a program where people can add categories. However, they do not show up when i make a query because I query like this: "SELECT CATEGORIES.ID, CATEGORIES.NAME, CATEGORIES.DEFAULT_PRICE, COUNT(PRODUCTS.CAT_ID) FROM CATEGORIES INNER JOIN PRODUCTS ON CATEGORIES.ID = PRODUCTS.CAT_ID GROUP BY CATEGORIES.ID, CATEGORIES.NAME, CATEGORIES.DEFAULT_PRICE;" using an INNER join. If I use a LEFT join, the categories with no products appear to have one. Problem!?! Thanks, Alex