I would like to execute a query with multiple joins and return an object with a hierarchy of sub-objects. Here is the query in SQL: select * from apt_code_lu lu join apt_main m on lu . apt_id = m . apt_id join apt_rwy_end re on m . apt_id = re . apt_id join apt_track t on re . rwy_end_id = t . rwy_end_id join apt_subtrack st on t . track_id = st . track_id join apt_seg seg on st . subtrack_id = seg . subtrack_id where lu . apt_code = 'ATL' and lu . cntry_code = 'US' Basically an airport contains
Read More...