Re: EuSQL

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

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

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

Search



Quick Links

User menu

Not signed in.

Misc Menu