Database API join fields
You should do

$query-&gt;fields('n')-&gt;fields('prospekt');


See the documentation for more info.

Note that querying field tables this way is not recommended as the tables are created dynamically. You should only fetch field data via APIs.