i don't get the solution for my needs:
my code:
select vocbox._id, vocbox.name, vocbox.native, vocbox.foreign, count(_id_vocbox) as count
from vocbox
left join vocable on vocable._id_vocbox=vocbox._id
group by vocbox._id;
...only delivers this:
but, what i want is this:
and this are my tables:
i hope somebody knows the right code.. :)
Aucun commentaire:
Enregistrer un commentaire