title: xmltable Oracle error : ORA-00905: Missing keyword
body: <p>I am trying to join data from xml table and schemas from other tables like:</p>
  <pre><code> for  przewod in (select prz.id, sr.kod, mat.kod
                    from xmltable (xmlnamespaces(default 'http://xxx/xx/xx-xx/xx/v1'),
                    'xx/xx' passing message.xx
                    columns
                    id varchar(20) path 'id',
                    xxxx varchar(20) path 'xxxx',
                    xx varchar(20) path 'xx') prz
                    left join sr.kod from z.a sr on sr.kod = prz.xxxx 
                    left join mat.kod from z.b mat on mat.kod = prz.xx )
  </code></pre>
  <p>but got always **** here:</p>
  <pre><code>left join sr.kod from z.a sr on sr.kod = prz.xxxx
  </code></pre>
  <p>why is that? what I am missing here? Just started with pl/sql and it is bit overwhelming :/ :)</p>
  <p>Thanks!</p>