How can I count Ikes from the relationship table

Asked

Viewed 46 times

0

Need

Select the posts along with the corresponding Ikes for each post. Cosegui select what I want, but when I use the error COUNT see in the first img.

Dice

The two tables also the post and the relationship to count the Likes.

inserir a descrição da imagem aqui inserir a descrição da imagem aqui inserir a descrição da imagem aqui

  • Assemble your structure in http://sqlfiddle.com/ and then mark me as I do SQL for you. It is interesting you show how you want the output, can mount in Excel and take a print here

  • The error you refer to is the null?

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.