Dofactory.com
Dofactory.com
 Back to list
Views:   1.4K
Replies:  0
Archived

Joining two table with count

I have two tables in my database 'nomination' and 'voting'
I want to join the two tables to list out the names  in the nomination according to their category columns then count the numbers of the occurrence of the nomination.id as submitted to the voting table  e.g

Politics
Joshua- 4 votes
Kennedy - 10 votes

Music
Chris Brown - 3 votes
West - 200 votes 

Oyewo Temidayo, Apr 10, 2018
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.