title: How do I split two or more inner joins into multiple select statements
body: <pre><code>SELECT e.cempnoee, e.cempname, e.cempemail, s.csrvposition, s.csrvbranch, s.csrvcostcentr, b.cbrndesc, p.caddnophoneh FROM emas e 
          inner join esrvc s on e.cempnoee = s.csrvnoee 
          inner join cbranch b on s.csrvbranch = b.cbrncode
          inner join eaddrs p on e.cempnoee = p.caddnoee
  </code></pre>
  
  <p>The SQL dialect I am using (Lianja/VFP) does not support multiple inner join statements as of the time of writing.  How do I split the above SQL statement into multiple select statements as a workaround?</p>