Re: EuSQL

new topic     » goto parent     » topic index » view thread      » older message » newer message 

Alex Chamberlain wrote:
> 
> 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!?!

Sorry I failed to mention that an INNER join does not show categories with no
 product!

Thanks,
 Alex

new topic     » goto parent     » topic index » view thread      » older message » newer message

Search



Quick Links

User menu

Not signed in.

Misc Menu