How to search multi types data in elasticsearch just like db's compound query

See more:

Elasticsearch

how to search multi types data in elasticsearch just like db's compound query. I am a green hand about elasticsearch ,I want to kown how to query data which in diffrent types.

GET books/fiction,adventure/_search
{
"query": {
"match_all": {}
}
}

please give some search condition,and the result comes from multi types ,just like db db's compound query.

select t1.*,t2.age,t3.name from t1 left join t2 on t1.id=t2.t1_id left join t3 on t3.id=t2.id
where t1.age>3 and t3.name like '....................

What I have tried:

I try to ask people from stackoverflow ,but they are lazy