[TYPO3-mvc] Database query inner join

[Michael Ruhdorfer]

hi all,

i have a problem with two tables (company and employees) in extbase where 1 company can have n employees.

but i want to access a list of the employees and need to know in which company they do work.

if i do an inner join in the repository i ain't getting a result. it isn't possible either to access "select * from company" in employee. it's confusing...

does anybody know what i am doing wrong?
thx in advance, michael