select count(resp_id) from 
table1,table5,table32,table63
where
table1.resp_id=table5.resp_id
and table5.resp_id=table32.resp_id
and table32.resp_id=table63.resp_id
and table1.field3=1 and table1.field8=1
and table5.field16=1 and table32.field7=1
and table63.resp_id=1