title: complex inner join sql
body: <p>You are my last hope. I've spend all day but I haven't decided how to create this query.</p>
  
  <p>This is my current database diagram</p>
  
  <p><a href="https://i.stack.imgur.com/PdYg8.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PdYg8.jpg" alt="enter image description here"></a></p>
  
  <p>Every storage have 1 roster</p>
  
  <p>Every roster consist from chief and worker. Information about them is on stuff table .</p>
  
  <p>What I try to do? Get all storage(square adress), worker_name, worker_surname, chief_name, chief_surname. </p>
  
  <p>What I have so far</p>
  
  <pre><code>select storage_address,
  storage_square,
   stuffs.stuff_name as chiefSurname, 
  stuffs.stuff_surname as chiefName from storages 
  inner join storageRoster on storageRoster.storageRoster_id=storages.storage_roster_id 
  inner join Chiefs on storageRoster.chief_id = Chiefs.chief_id 
  inner join stuffs on Chiefs.chief_stuff_id = stuffs.stuff_id
  </code></pre>
  
  <p>But in this query I can only get chiefs on every storage. Help please. I am desperate.</p>