Aeterna 0 Newbie Poster

select * from a where a.b_id = $b_id and select count(*) from c where c.a_id = a.id and select count(*) from d where d.a_id = a.id

whats the proper way to write this?