php - display duplicates according to count? -


i have 2 tables books , bkdates want duplicates according count
books
id|name|edno
1|book1|1
2|book2|2
3|book1|1
4|book2|2
5|book1|1
6|book3|3


bkdates
edno|year
1|1980
2|1990
1|1980
1|1988
2|1991
2|1990
1|1980
3|2003


expected output edno|year|count
1|1980|3
1|1988|1
2|1990|2
2|1991|1
help??!

select edno, year, count(edno) bkdates group year


Comments

Popular posts from this blog

jquery - How do you format the date used in the popover widget title of FullCalendar? -

asp.net mvc - SSO between MVCForum and Umbraco7 -

Python Tkinter keyboard using bind -