select `id`,`name`,`age`,`address_id`,(select `street` from `address` where `person`.`address_id` = `address`.`id` ) `address` from `person` where `person`.`age` > 18 and `person`.`name` = "C. Vogt" [:a_2, :a]