title: Select query with many to many relationship
body: <p>i have thi DB structure</p>
  
  <pre><code>CREATE TABLE man (
      id INTEGER PRIMARY KEY AUTOINCREMENT,
      name TEXT
  );
  
  
  CREATE TABLE work (
      work_id INTEGER PRIMARY KEY,
  );
  
  CREATE TABLE manWork {
      man_id INTEGER,
      work_id INTEGER,
      FOREIGN KEY(man_id) REFERENCES man(id),
      FOREIGN KEY(work_id) REFERENCES work(work_id)
  };
  </code></pre>
  
  <p>how will the SELECT query if I want to get a list of all men and for every man also all the jobs associated to that man?</p>