Query for related data ("join") in the API ?

Is it possible to do a “join” in an API query, for example if there is a relation between tables 1 and 2:


I suppose you can do similar kind of join by brining the field from table 1 into table 2 through having Link and Load with table 1 key field or vice versa.