title: How to Select from four tables in sql?
body: <p>This is the table structure</p>
  
  <p>plinks</p>
  
  <ul>
  <li>link</li>
  <li>ojectidfk</li>
  <li>uidfk</li>
  </ul>
  
  <p>ojects</p>
  
  <ul>
  <li>ojectid</li>
  <li>uidfk</li>
  <li>ojectname</li>
  </ul>
  
  <p>Try</p>
  
  <ul>
  <li>useridfk</li>
  <li>ojectidfk</li>
  <li>goryidfk</li>
  </ul>
  
  <p>gory</p>
  
  <ul>
  <li>goryid</li>
  <li>goryname</li>
  </ul>
  
  <p>What i want to do is select the <code>ojectname</code> from <code>ojects</code> where the <code>plinks projectidfk</code> is the same in ojects and <code>plinks</code> but select everything from try where the <code>ojectid</code> is equal to the <code>ojectsid</code> where <code>pinks link = 8493284 AND gory id = try goryidfk</code></p>