Re: Query - costruire un sommario (HELP)
Qualcuno mi ha suggerito di usare una join!
SELECT qz_categories.id, qz_categories.name, COUNT(qz_questions.category_id) as total
FROM qz_categories LEFT JOIN qz_questions ON (qz_questions.category_id = qz_categories.id)
GROUP BY qz_categories.id
Funziona a meraviglia!
Spero almeno questo post possa tornare utile a qualcuno! ;)
Subject
Views
Written By
Posted
4426
August 30, 2007 05:32AM
Re: Query - costruire un sommario (HELP)
2773
August 30, 2007 07:13AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.