0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select * from 
votetypes
left join (
select count(*) as num, votetypeid 
from votes
where postid = 194812
group by votetypeid) a
on a.votetypeid = votetypes.id

fork query

edited feb 5 12

created feb 5 12 jon.doe7330