jeudi 30 avril 2015

SQLite (select): i don't get it

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: enter image description here

but, what i want is this: enter image description here

and this are my tables:

enter image description here

i hope somebody knows the right code.. :)

Aucun commentaire:

Enregistrer un commentaire