title: Mysql 'LEFT JOIN' for "exec_SELECTquery" in typo3 version 6.2
body: <p>I have a query </p>
  
  <pre><code>$query = 'SELECT DATETIME, message, username
              FROM t_messages
              LEFT OUTER JOIN fe_users ON t_jobs_messages.sendto = fe_users.uid
              WHERE t_messages.uid =25;
  </code></pre>
  
  <p>I need to convert it to <code>exec_SELECTquery</code> style.
  like</p>
  
  <pre><code>$res = $GLOBALS['TYPO3_DB']&gt;exec_SELECTquery('message, username','t_messages','t_category','t_messages.uid =25');
  </code></pre>
  
  <p>How can I use LEFT OUTER JOIN in the above format.
  Thanks in advance.</p>